View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Paul Black Paul Black is offline
external usenet poster
 
Posts: 394
Default 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