Truncating text field in column

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?
 
D

Dave Peterson

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.
 

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

Top