A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Merging Columns



 
 
Thread Tools Display Modes
  #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




Ads
  #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



  #13  
Old March 8th, 2010, 08:56 AM posted to microsoft.public.excel.worksheet.functions
Endalk Tessema
external usenet poster
 
Posts: 1
Default Merging Columns

Hi was trying to merge two colums in to one, and both columns have about 500
client lists. In column A I have first name and in Column B I had Clients
last name. But I wanted to do both in on columns. So instead of doing one at
a time I created the following formula in C 1
=CONCATENATE(Sheet1!$A:$A&" "&Sheet1!$B:$B)
.... then I select my Formula in C1, then select all the way to client nuber
500 (C500), that means I have highlighted the column C1 to C500, then click
Fill, then click down. That makes the same exact formula from C1 to

C500. then enter. That will merge all the values in column A and column B.
Note: pls note in the formula there two same words Sheet1. That is the
sheet you are working on. Normally when we open excel we have Sheet1, Sheet2
and Sheet3 at the bottom of the worksheet we are currently working. So If you
already renamed it pls use your name instead of Sheet1, or Sheet2 if you are
working on sheet 2.
--
www.wilshiretrans.com
Limos, Taxis, Shuttles, Stretches, and Buses.


"David Biddulph" wrote:

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




  #14  
Old May 31st, 2010, 09:36 PM posted to microsoft.public.excel.worksheet.functions
vhnbvb
external usenet poster
 
Posts: 1
Default Merging Columns

thank you

"Titanium" wrote:

Gord, I could be wrong, but I believe the reason Roger's formula didn't work
for me is because of the spacing. Your formula worked perfectly fine. I do
appreciate the help of both Roger and yourself. You saved me countless hours
of hellish copy & pasting monotony...

"Gord Dibben" wrote:

In C1 enter =A1 & " " & B1

Double-click on fill handle of C1 to copy down.


Gord Dibben MS Excel MVP

On Sun, 29 Jul 2007 08:06:02 -0700, 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





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:54 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.