How to convert a date value in an Excel 2003 file that is presently separated out into 4 columns (C thru F) so that it is consolidated into column C?

How to convert a date that is presently separated out into 4 columns so that it is consolidated into column C?
I am working with an Excel 2003 file. Attached are sample records from the Excel file.
For the rows after the header, I would like to convert the values in:

columns C, D,E,F into column C.

Thus, the first record would be changed from:

Col A        Col B        Col C         Col D       Col E        Col F

5454        UNA          Jan              10             2013          9:26AM

Revised value for first record:

Col A        Col B        Col C

5454         UNA         Jan 10 2013 9:26AM
Test3.xls
zimmer9Asked:
Who is Participating?
 
Paul PayneConnect With a Mentor Managing ConsultantCommented:
If you insert a column into C then paste the formula into C2 (assuming you have headers in your file) =CONCATENATE(D2," ",E2," ",F2," ",G2) not sure if this is what you are after.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.