Substitute and Arrays

[Tryllast]

What I am trying to do is eliminate all numeric characters from a text string in a cell...

I know the following works but it gets quite large...

assume G2 = 23ea
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G2,0,""),1,""),2,""),3,"") all the way up through 9
results in: ea

What I would like to know is can I get something like this to work...

=substitute(g2,{1,2,3,4,5,6,7,8,9,0},"")


would also be open to another method that I am missing that might be a more efficient solution.

 

[circledchicken]

Hi and welcome to the forum,

Are the numbers always at the start? If so, maybe:

=SUBSTITUTE(
     A1,
     LOOKUP(
       9.99999999999999E+307,
       --LEFT(A1, ROW(A$1:INDEX(A:A, LEN(A1))))),
     "")

 

[Tryllast]

Thank you for the response, in this case they will always start with numbers but future situations where this would be required may not.