That will work as well, essentially that is what the CONCATENATE() function
does behind the scenes.
--
Regards,

DavidB


"Duke Carey" wrote:

Or:

=C1&" "&D1

"DaveB" wrote:

In column J (or wherever you have a free column) type this:

=CONCATENATE(C1," ",D1)

and drag down. Then copy this column and paste special-values into column
C or D. Use the same process for column H and I
--
Regards,

DavidB


"Jay T" wrote:

I have an excell worksheet that comes with the following information in each
column (not rows).

A First Name
B Last Name
C House Number
D Address
E City
F State
G Zip Code
H Area Code
I Phone Number

I need to merge the information in C with D (i.e. 123 Main Street in same
column). I also need to merge information from H with I (504 555 1212)

Help.