i want the cell to appear as blank, if letters are detected in the cell

[ChloeW]

hi there!

Trying to find out If there is formula where letters can be detected in the cell, remove it, and resulting in a blank cell?

thank you! appreciate the help!

[cjaneczko]

Specific letters or any time a letter is detected? Can you provide an example of the data you are working with and how you want it to look?

[binuacs · Accepted solution]

@ChloeW Something like this?

[ChloeW]

thank you so much! it works !