Jan 23 2018
07:37 AM
- last edited on
Jul 25 2018
10:51 AM
by
TechCommunityAP
Jan 23 2018
07:37 AM
- last edited on
Jul 25 2018
10:51 AM
by
TechCommunityAP
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!
Jan 23 2018 08:45 AM
René,
Try this formula:
=REPLACE(A1,1,7,"**** **")
And this:
=REPLACE(A1,1,7,"xxxx xx")