View Single Post
  #4   Report Post  
Nick Hodge
 
Posts: n/a
Default

Chuck

Data in A2 enter in B2

=MID(A2,4,LEN(A2)-3)

And copy down

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

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