Extract only text from Text-Numeric value of Cell in Excel?

excel
data_wrangling

#1

Dear All,

Please help me to solve one of the problem that I am facing.

In one of the columns, I have values which are a mix of text & numeric type in sorted manner. Now I want to extract only the text part out of it.

There is no any specific trend of text and number arrangement, it is different for different cells: e.g. cell B2 has a value “est234rtet567ret” and for cell B3m the value is 45tery345try23.

Regards,
Mukesh


#2

@Mukesh

You can use SUBSTITUTE & TRIM functions to perform what you need.

Following formula can be used to remove whole numbers from string and it will return only text.
=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,0,""),1,""),2,""),3,""),4,""),5,""),6,""),7,""),8,""),9,""))

Regards,
Sunil