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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to type each letter of the alphabet automatically in a specific color in Word? 0
counting ROWS that have 2 criteria 7
cell reference 1
Counting how many numbers and letters appear in a particular row 7
Excel Help to copy information from one row at a time to another sheet 1
Why is my header row numbers instead of letters? 2
Easiest Way to Delete Rows 4
column & row names printed - a, b, c etc 1

Top