Link to home
Create AccountLog in
Avatar of daisypetals313
daisypetals313Flag for United States of America

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)
ASKER CERTIFIED SOLUTION
Avatar of Professor J
Professor J

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of daisypetals313

ASKER

This worked great!  I used your formula:

=SUBSTITUTE(SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE(SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE(A1,"1",""),"2",""), "3",""),"4",""),"5",""), "6",""),"7",""),"8",""),"9",""),"0","")