zimmer9
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.