Datatext to columns, fixed width click next, click after the 3rd character
and click next, select the left column and check do not import (skip), click
finish

another easy way would be to insert a new column adjacent to the one you
need to remove the characters from, assume the data is in A, if column B is
empty select the first adjacent cell, if it's not empty select the B column
and insert new column, the old B is now C, in B1 put

=MID(A1,4,255)

press enter, select B1 again, move the cursor to the lower right corenr of
B1 and when it changes from a fat cross to a thin cross double left click
with the mouse
and the formula will be copied down as long as there are values in A, while
still selected copy it, then do editpaste special as values in place.
Finally delete column A if it's not needed.

If you do this often you can record a macro when you do the text to columns


Regards,

Peo Sjoblom

"Chuck" wrote:

Is there a single command/formula to remove the first 3 letters in each of
the fields in an entire column?