J
Jen96
Can someone assist me with merging the data in four fields into one string of
information?
information?
B
BekkiM
Assuming your addresses are in A1, B1, C1, and D1, put the following formula
in E1:
=CONCATENATE(A1, " ",B 1," ",C1," ",D1)
The " " is to leave spaces between the elements of your address. If you
need commas or other delineation characters, just make sure to put them
inside the double-quotes.
in E1:
=CONCATENATE(A1, " ",B 1," ",C1," ",D1)
The " " is to leave spaces between the elements of your address. If you
need commas or other delineation characters, just make sure to put them
inside the double-quotes.
J
Jen
Hi Bekki,
I did exactly what you advise to do below, but I get an error msg that it
does not recognize the formula...the cell is formatted to general (or
'standard' since I am using it on a French keyboard & system. All I want to
do is combine about 5 cells to create an adress in one cell..HELP+"*ç%&/()=
Jen
I did exactly what you advise to do below, but I get an error msg that it
does not recognize the formula...the cell is formatted to general (or
'standard' since I am using it on a French keyboard & system. All I want to
do is combine about 5 cells to create an adress in one cell..HELP+"*ç%&/()=
Jen