| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting a text word or text string to a number | Excel Discussion (Misc queries) | |||
| Converting a date to a text field w/o converting it to a julian da | Excel Worksheet Functions | |||
| Converting Text to Date using "Text to Columns" | Excel Discussion (Misc queries) | |||
| Converting text from rows to columns | Excel Worksheet Functions | |||
| converting numbers to text and prefill text field with 0's | Excel Discussion (Misc queries) | |||
Linear Mode
