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 |
#1
|
|||
|
|||
converting text to columns
I have a column of dates that have been imported from a CSV file. The format
is month year (209, 1112, 1211, etc.). I need to separate the month and year into separate columns using "converting text to columns." However, because some of the numbers are only 3 digits, I can't separate using fix width and it is not delimited. In excel, the column is right justified, but when using the separating tool, it looks left justified. Help. |
#2
|
|||
|
|||
converting text to columns
After importing (in Col A) use this in B1 to get the month
=MID(A1,1,LEN(A1)-2) and this in C1 to get the year =Right(A1,2) "Linda (Irwin)" wrote: I have a column of dates that have been imported from a CSV file. The format is month year (209, 1112, 1211, etc.). I need to separate the month and year into separate columns using "converting text to columns." However, because some of the numbers are only 3 digits, I can't separate using fix width and it is not delimited. In excel, the column is right justified, but when using the separating tool, it looks left justified. Help. |
Thread Tools | |
Display Modes | |
|
|