A very common problem is how to remove numbers from text cells in Excel. For some reason various systems mix up text and numbers but there are lots of methods for removing numbers but I show you with formulas

  • From below table I am show you how to remove number
  • Type the Formula 
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,1,""),2,""),3,""),4,""),5,""),6,""),7,""),8,""),9,""),0,"")
  • Replace cell A2 with yours