Truncating text field in column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text field in an Excel spreadsheet with (for instance) 10
characters. I wish to truncate the first 5 characters and leave the rest. Is
there an easy way to do that in Excel?
 
Select the column/field.
(xl2003 menu system)
Data|Text to columns
Fixed width
draw a line between the 5th and 6th characters
erase any other line that excel may have guessed

Choose "Skip/Do not import" for the first portion of that field
and finish up that wizard.
 
Back
Top