Thread: Merging Columns
View Single Post
  #11  
Old July 30th, 2007, 04:04 PM posted to microsoft.public.excel.worksheet.functions
Steve B
external usenet poster
 
Posts: 50
Default Merging Columns

I was having this same problem...However the two columns I am trying to merge
have a date and the time. So when I merge the two columns I am getting the
number form of the date in return. I have tried changing the format to show
the date and the time but its still returning the number? What should I do
to fix this problem?

B2=7/23/07
C2=0:00:16

What I want in D2 is: 7/23/07 0:00:16
What I am getting is: 39286 0.00185185....
"Titanium" wrote:

I am trying to 'make one' a number of columns...
Essentially I have several thousand rows of data that I need to clean up...
What I would like to accomplish is Column A + B = AB

Column A Data: I need this one first
Column B Data: and this one comes right behind with a space for proper grammer
To equal one column: I need this one first and this one comes right behind
with a space for proper grammer.

Thanks in advance for any input!

Ti