Excel Guides

Getting Rid of Alphabetic Characters in Excel

There are a few ways to get rid of alphabetic characters in Excel. One way is to use the SUBSTITUTE function. This function replaces one character with another character. So, if you wanted to replace all of the alphabetic characters with numbers, you could use the following formula:

=SUBSTITUTE(A1,CHAR(ROW(INDIRECT("A"&MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),9^9)))),"")

Another way to get rid of alphabetic characters is to use the TRIM function. This function removes all spaces from a text string. So, if you have a lot of spaces in your data that you want to get rid of, you can use the TRIM function. For example:

=TRIM(A1)

If you want to remove all non-alphanumeric characters from a text string, you can use the CLEAN function. For example:

=CLEAN(A1)

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.