Can every type of text become an X?

[Antonio Castagnella]

Hello,
I have a question about Exel: can every type of text  become an X?
When I put a text, any type, I would like to trasform it in an X, is it possible?
Thank you.
Regards.
Antonio

[#2]

Hi @Antonio Castagnella

Using find and replace function

Give "?" in find, replace with "x".

Ask if you want anything than this.

[#3]

Hi Antonio,

If you want to show the text as X you may apply custom format to your cells as

#,##0.00;-#,##0.00;0;X

selecting most suitable for numbers part.

If the goal is to change the content of the cell with the text on X when, as posted, to replace it or use some VBA to do that on the fly.