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.

"Jen96" wrote:

Can someone assist me with merging the data in four fields into one string of
information?