combining two columns into one-Excel 2007
On Jul 5, 10:38 pm, Stephen wrote:
I have two columns of information. The first contains the date and the second
contains a number. I want to combine these two into a single column where
the date is the first piece of data and the number is the second, etc. etc.
I have about 15000 sets of data (date and number), so to do this manually
would be out of the question.
Any suggestions for a "novice" programmer?
Thanks
Steve
Hi Steve,
You could use the concatenate function.
Assuming the date is in cell A1 and the number is in cell B1, in cell
C1 enter the formula :-
=A1 & " " & B1
Hope this helps.
All the Best.
Paul
|