Thread
:
Remove 1st 3 characters in each field of Excel column
View Single Post
#
4
Nick Hodge
Posts: n/a
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?
Reply With Quote