Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Address is in separate fields
Can someone assist me with merging the data in four fields into one string of
information? |
#2
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Address is in separate fields
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 "BekkiM" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I take some of my Excel fields and make address labels? | Excel Discussion (Misc queries) | |||
Separate address column to Five columns | Excel Worksheet Functions | |||
MIN Function w/ variable address reference | Excel Worksheet Functions | |||
How do I stop e-mail address from turning into link in Excel? | Excel Discussion (Misc queries) | |||
Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) |