View Single Post
  #3   Report Post  
Dave R.
 
Posts: n/a
Default

Try

=RIGHT(A1,LEN(A1)-3)

in an adjacent cell, then copy down as far as needed, then copy and paste
special as values.

You can also use datatext to columns and choose "Fixed width". Now click on
the window display to insert a line 3 characters in. If you click 'finish',
you'll have the 4th+ characters in the next column (you can also specify
where you want the results to go if you don't want them in the next column).
You can then delete the column with the original 3 letters.



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