Mass Delete each Letter in front of number in each row.

Hi,

I'd like to delete each letter in front of the number in each row in multiple rows in one column.

Example:

S3
D4
C17
D5
G6
R55

Just want to mass delete all the letters so it shows up like this:

3
4
17
5
6
55


Thanks!

Dino

Originally Posted by Dno

Hi,

I'd like to delete each letter in front of the number in each row in multiple rows in one column.

Example:

S3
D4
C17
D5
G6
R55

Just want to mass delete all the letters so it shows up like this:

3
4
17
5
6
55


Thanks!

Dino

assuming that you have only a single character at the begining and you data is in col A starting from cell A1 then put in B1
=MID(A1,2,50) and copy this function down in col B.

Regards.

If you have more than one alpha charachter in front you may want to try this array formula...

=MID(A1,MATCH(FALSE,ISERROR(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)*1),0),LEN(A1))

Remember to enter this with Shift-Alt-Enter

Also, this will not remove numeric values behind the numbers.

Hope that helps,
John

Hey thanks alot