Combining data from several cells into one cell

Bketchum

New Member
Joined
Oct 5, 2006
Messages
12
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
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

mbb4331

Board Regular
Joined
Dec 22, 2005
Messages
152
In A5,

=trim(A1) & " " & trim(A2) & ", " & trim(A3) & " " & trim(A4)
 

Watch MrExcel Video

Forum statistics

Threads
1,111,910
Messages
5,541,533
Members
410,547
Latest member
htran4
Top