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



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.




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.