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