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.