I have a spreadsheet which I am going to use as a merge into a word doc. I have 4 columns for my address (1- Address 2-City 3-State 4-Zip) I would like it if once the data is entered into those 4 fields, for excel to combine the data into one cell. Example:
in cells:
A1 - 123 Main Street
A2 - New York
A3- NY
A4- 10583
In cell A5 it should read: 123 Main Street New York, NY 10583
Can this be done? I found that I can separate cells, but how do I do the opposite and combine them. Or do you have other ideas. I want to merge only 1 cell into Word, rather than having to merge 4 fields into the same line in Word.
Any help would be appreciated!
Brooke
in cells:
A1 - 123 Main Street
A2 - New York
A3- NY
A4- 10583
In cell A5 it should read: 123 Main Street New York, NY 10583
Can this be done? I found that I can separate cells, but how do I do the opposite and combine them. Or do you have other ideas. I want to merge only 1 cell into Word, rather than having to merge 4 fields into the same line in Word.
Any help would be appreciated!
Brooke