merged data into one

[singkit]

Hi,

Please help. I need to merged data of Column 1 - 3 into
Column 4.
For example.
Sheet 1
Column 1 Column2 column3 Column4
John T Cruz John T Cruz
Anna F Chua Anna F Chua

Thanks.

 

[Max]

Try in D1: =TRIM(A1&" "&B1&" "&C1)

Copy D1 down

 

[Frank Kabel]

Hi
try the following in D1
=A1 & " " & B1 & " " & C1
copy down

 

[Hans]

Hi

Try:

=CONCATENATE(A1," ",B1, " ",C1)

Hans

 

[singkit]

Thank you so much!!!

-----Original Message-----
Try in D1: =TRIM(A1&" "&B1&" "&C1)

Copy D1 down

--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
----



.

 

[Max]

You're welcome !

 

[David Hall]

Use =CONCATENATE(A1," ",B1," ",C1)

 

[Leo Sun]

Thank you!

You're welcome !