merging 3 cells into 1

[joe54345]

Here's an old post about merging 2 columns into one, how can I amend
this formula to make it 3 columns into one maintaining both sets of
data?


C1: =A1 & " " & B1


now say I want to merge columns A, B, and C?

 

[Nick Hodge]

Joe

If I understand

=A1&" "&B1&" "&C1

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

(e-mail address removed)
www.nickhodge.co.uk

 

[Carim]

Hi,


In cell D1 :

=A1&" "&B1&" "&C1


Carim

 

[Guest]

Try this; I do it all the time.

D1: =A1 & " " & B1 & " " & C1

 

[joe54345]

Thanks all! There's a little problem though, Column A is the Date
10/20/2006, for some reason it's coming out in the merge as "39010",
any way to get the date to show as it is printed?

 

[Dave Peterson]

=text(a1,"mm/dd/yyyy") & " " & ....

Thanks all! There's a little problem though, Column A is the Date
10/20/2006, for some reason it's coming out in the merge as "39010",
any way to get the date to show as it is printed?