splitting unmerged cells issue

  • Thread starter Thread starter Sarnath
  • Start date Start date
S

Sarnath

Help please- I have an excel file that is a result of an oracle report
feed with some 42,000 rows. I'm trying to split fields that contain
both a date and time in it (mm/dd/yyyy mm:ss,0). After going through
the "text to column" wizard, some of the values are still left in the
original cell- it cuts off the first number on the time and leaves it
with the date even though the divider line in the setup box shows it to
cut through it correctly. It only does this on certain rows and I
cannot find a rhyme or reason for it. I have messed with the column
format/number/date, but it does not seem to help.
 
Sarnath
Say the data you want to split is in Column A. Insert a new blank
column as Column B. Copy everything you have in Column A and paste it to
Column B. Now format Column A for date (Format - Cells - Number tab - Date)
and Column B for Time. Done. HTH Otto
 
Instead of a fixed split choose "Delimited" in the first pane of the
Text to Columns wizard, then check the Space checkbox in the second.
Click Finish.
 
Back
Top