#1
|
|||
|
|||
Merging cells and keeping all the data/values
Hi, I have an exported data table that contains names and addresses. I need to have the address field "No, Street name, suburb, zip code, state" all in the one field. However this exported data table has these values in separate fields. How can I merge the fields and bring all the values into one single field.
thanks Paul |
#2
|
||||
|
||||
H
have a look at the CONCATENATE function or use the "&" to concatenate cell contents like =A1&B1&C1
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
merge data, mergefield address word |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Loss of formulae values when mail merging excel to word | MellowMel | Mail Merge | 6 | 05-09-2014 09:08 AM |
Merging excel values to text file | daymaker | Excel | 18 | 10-24-2013 12:45 AM |
Merging and Shading Cells based on Dates | stockers | Excel Programming | 0 | 03-07-2013 02:32 PM |
Merging three columns of data | jdjette | Excel | 7 | 03-02-2012 04:48 PM |
Change values in cells based on criteria | SaneMan | Excel Programming | 2 | 02-02-2012 07:58 AM |