Help with formula or cell form

Copper Contributor

Hi! Is there a way to change to first numbers of a serie by " * " or "x" ? Ex. I would like that 0000 000000 000000 is replace by **** **0000 00000 or xxxx xx0000 00000. Thank's!

2 Replies

René,

 

Try this formula:

=REPLACE(A1,1,7,"**** **")

And this:

=REPLACE(A1,1,7,"xxxx xx")

 

Thank you soooo much!