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