delete prefex

[supers7167]

I have a column of which each cell has a 3 letter prefex followed by 4 numbers.

How can I delete the prefex and leave the 4 four numbers, the whole column at one time?

 

[VoG]

If your codes start in A1 then in B1 enter

=RIGHT(A1,4)


and copy the formula down.

 

[Richard Schollar]

Hi

Data>TextToColumns>Fixed Width>Next and place a divider between the 3rd and 4th character>Next>Skip import of first column>Finish

 

[supers7167]

Works great. Thank You.