Thread: Merging Columns
View Single Post
  #12  
Old July 30th, 2007, 04:57 PM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
 
Posts: 8,714
Default Merging Columns

In your situation, don't try to do a text concatenation.
Just use =B2+C2 and format the cell appropriately, such as:
mm/dd/yyyy hh:mm:ss
--
David Biddulph

"Steve B" wrote in message
...
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