im working in a office, so i want to mask some data with asterisks (numbers or text) to the next column, like this:
13067601701 -> ****7601701
but i cant find the way or formula or whatever is this. i serach to the internet but cant find the way to work in my excel.
36 freelancere byder i gennemsnit €8/time for dette job
Greetings! It is pretty straightforward - please try the formula "REPLACE(A1,1,4,"****")" and let me know your feedback. Have a Great Week Ahead! Srinivasan
Hi, I can create the formula to hide first 4 letters and display asterisk for them in few minutes. I am ready to provide the solution right now....just waiting for your reply. Regards
Hi there, Yes! Let me do it so simply using Python. Will deliver portable CLi app for your job. Great exp in data processing including regex. Wish to be hired. Serious bidder. Best regards, Ishaq
Hi there! Seems like a small problem I can help you save some money on. Drop me a message to share with me more details I am usually available from 8 AM to 11 PM (GMT+8) and will reply within an hour. Cheers!
Excel expert here, ready to fix this for you right away. This will be an easy formula using a new column with left()/right()) or formatting with format cells 000,,"-**-****" Depends on your preference.