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.
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.
Last edited: