ExcelBanter - View Single Post

Dave Peterson

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

wrote:

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 Mc wrote:
Try this; I do it all the time.

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

" wrote:

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?

--

Dave Peterson