remove 1st 2 letters in each row

  • Thread starter Thread starter Cathy
  • Start date Start date
C

Cathy

I have 30 rows and each row I need to delete the first 3 letters.
ex
UNE127
UNE50

so it will be 127
50

Can someone please tell me how I can do this without going in and
deleting each row.

Thanks
 
A simple MID might suffice
Assume your data in A2 down
In B2: =MID(A2,4,99)+0
Copy down. The "+0" bit will convert the extracted text nums to real
numbers. Success? hit the YES below
 
Back
Top