Hi All:
I did a quick search but did not fine what I was looking for (too many results).
I need to combine some data that is currently in 2 columns (G and H). The problem I am having is trying to get a carriage return in there so that the info from Column H goes below the info from Column G. I placed a carriage return in J and tried this:
=CONCATENATE(G7 & J7 & H7)
The info went together but all on one line. Is what I am asking for possible and if so how? These are all address listing like this:
G7 = "4000 Sheppard Avenue East"
H7 = "Scarborough, Ontario M1S 4X4
I need my result shown as:
4000 Sheppard Avenue East
Scarborough, Ontario
M1S 4X4
Any suggestions?
THANKS,
Mark
I did a quick search but did not fine what I was looking for (too many results).
I need to combine some data that is currently in 2 columns (G and H). The problem I am having is trying to get a carriage return in there so that the info from Column H goes below the info from Column G. I placed a carriage return in J and tried this:
=CONCATENATE(G7 & J7 & H7)
The info went together but all on one line. Is what I am asking for possible and if so how? These are all address listing like this:
G7 = "4000 Sheppard Avenue East"
H7 = "Scarborough, Ontario M1S 4X4
I need my result shown as:
4000 Sheppard Avenue East
Scarborough, Ontario
M1S 4X4
Any suggestions?
THANKS,
Mark