How to remove numbers from a cell in excel
By
SpreadCheaters
You can watch a video tutorial here.
You have a cell with text and numbers, but want to remove all numbers from the cell.
There’s a way to do this with a nested SUBSTITUTE function:
Step 1 – Understanding the Syntax
– Select the cell that you would like to see the result in.
– Type =SUBSTITUTE( and select the cell you need to calculate
– Type , and type the character you want to substitute, in this case, we will use a 0.
– Type , and type what you would like to substitute the character with.
– In this case, we want it to substitute with nothing, so we type in “”.
– Close the formula bracket.
Step 2 – Nesting the formula
– Edit your formula by adding SUBSTITUTE( in front of the first SUBSTITUTE.
– Behind the closed bracket ), Type ,1,””).
– Your formula should look like this: =SUBSTITUTE(SUBSTITUTE(A2,0,””),1,””)
– Repeat these steps up to 9 so your formula looks like this:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,0,””),1,””),2,””),3,””),4,””),5,””),6,””),7,””),8,””),9,””)
This is the easiest way to remove numbers in Excel without using VBA.
