remove 1st 2 letters in each row
 

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

remove 1st 2 letters in each row
 

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
--
Max
Singapore
---
"Cathy" wrote:
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