Search for any number

Question

I'm trying to eliminate all numbered content in a column of cells in Excel. Isn't there a way to search for any number & replace with a white space? It seems to me I used to be able to do this in Excel for Windows; I' don't see how to do this on a Mac. Can anyone help?

Answer 1

Excel’s normal Find and Replace does not have a wildcard that means “any digit.”

You might want to consider using a helper column, then use this formula (if the cell is A2), then drag it down. And then copy and value and paste (use paste special > values) to the column you want.

=REGEXREPLACE(A2,"[0-9]+","")