Extract text from alphanumeric value using Excel Formula


Excel Course : The Ultimate Excel Programmer Course

Q : Mark asked if we can extract text from alphanumeric value using excel formula.

Solution : Suppose alphanumeric value is placed in cell A2.

Enter the following formula in cell B2.



How it works ?

The Microsoft Excel SUBSTITUTE function replaces a set of characters with another.

Trick : The above formula replaces 1 through 9 with blank value. Hence, all the numeric values are rubbed out from the alphanumeric string.

Coursera Data Science

Excel Tutorials : 100 Excel Tutorials

Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*

Related Posts:

0 Response to "Extract text from alphanumeric value using Excel Formula"

Post a Comment

Next → ← Prev