Forum Discussion
Help with formula or cell form
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!
René,
Try this formula:
=REPLACE(A1,1,7,"**** **")
And this:
=REPLACE(A1,1,7,"xxxx xx")
- Thank you soooo much!
