Thread: Merging Columns
View Single Post
  #13  
Old March 8th, 2010, 09: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