Mask SSNs in a Spreadsheet

How to hide Social Security Numbers by changing them to XXX-XX-1234 using a few easy steps. Note: These SSNs are fictional, so don't get too excited.
Learn more from Prolific Oaktree:
🌳 Next Video - Google Sheets | Sort and Filter by Color • Google Sheets - Sort a...
🌳 Related Playlist - Google Apps | Full Tutorials - bit.ly/google-...
#googlesheets #spreadsheets #prolificoaktree

[@karenaranda3553]

These are wonderful instructions it helps me not to have to mask SS#'s for the entire company.

[@ProlificOaktree]

Awesome! Glad it helped you out.

[@tracywellman6238]

Great instructions - thanks so much!

[@cscomputersvg]

If a number in an Excel sheet is already masked, then how can we see that masked number?

[@ProlificOaktree]

You most likely can't.

[@dkcreation1877]

how to unmask ?

[@TESTTEST-vn9ss]

Excellent instructions, thanks!

[@ProlificOaktree]

You're welcome!

[@sumankarmakar5462]

Is there any way to unmasked the data again, as I have deleted the original file.

[@ProlificOaktree]

If you are using Google sheets in a desktop browser, try File -> See Revision History. If you are using Excel, you are probably hosed. That is assuming that the "undo" function won't get you all the way back to before you did it.

[@srinivasms9175]

How can I remove mobile number 90xx45xx81 Iwant to remove xxxx.see that full number. It's possible

[@sriseetharamasemenbank6039]

i have masked excel sheet frm dowladed. i want un masked it how

[@rymbourenane]

Thank you SO much. This saved me!

[@ProlificOaktree]

Great!

[@cindydelacruz31]

THANK YOU!!! Life saver

[@ProlificOaktree]

Glad it helped!

[@MsCoCoHampton]

OMG ... PERFECT!!!!!

[@upamanyubarik8058]

I need unmasked data means *****245 to its original number

[@ProlificOaktree]

If you figure out how to do that, let me know. I'll try it for the next lottery.

[@RahulKumar-mb5wn]

i need middel number how

[@ProlificOaktree]

Try the MID function. That will be what you need.

[@skkarmakar8152]

Excellent

[@ProlificOaktree]

Thank you sir.

[@Duckeydoo701]

This is not masking the value
This is changing the value