Hello,
My current query is showing as ADDRESSLINE1: StrConv([Address],3) & "|" & StrConv([Address2],3) to incorporate 2 address lines into 2 with a | in between and correctly formatted. However, I need Address2 to be moved onto the new line so when a spreadsheet is outputted it looks like the below for example, but within one cell:
6 The Station
London
I have tried putting Ctrl + Enter in between the " " instead of a | but that doesn't seem to work.
Any help