remove 1st 2 letters in each row

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
 
M

Max

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
 
Top