daisypetals313

asked on

# Modification of formula that copies only letters and not numbers

The below array formula copies only the letters from a cell and ignores the numbers, however, it only seems to work when the cell starts with a letter. How would I update the below to work if the cell starts with a number?

=LEFT(A1,IF(MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0 123456789"))>LEN(A1),0,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")))-1)

=LEFT(A1,IF(MIN(SEARCH({0,

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

ASKER

=SUBSTITUTE(SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE(SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE(A1,"1",""),"2",