converting text to columns

L

Linda (Irwin)

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.
 
S

Sheeloo

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format column widths from one table to a separate table on same page 1
Convert numbers stored as text to numbers - Automatically - Macro 2
Convert numbers stored as text to numbers - Automatically (NO Macrosor VBA) 0
Text to Rows 0
Convert Text to CSV format 3
How To Compare Two Csv Files Mainly Two Columns Containing Time 0
1 Column 'Date' to 3 Seperate Columns 'Month, Day, Year' How?? 0
Date and Number cell formats 4

Top