With DocHub, you can easily work in social security number in spreadsheet from any place. Enjoy capabilities like drag and drop fields, editable text, images, and comments. You can collect eSignatures securely, add an additional level of protection with an Encrypted Folder, and collaborate with teammates in real-time through your DocHub account. Make changes to your spreadsheet files online without downloading, scanning, printing or mailing anything.
You can find your edited record in the Documents folder of your account. Edit, submit, print, or turn your file into a reusable template. With so many advanced tools, it’s simple to enjoy trouble-free document editing and management with DocHub.
Iamp;#39;d just like to show you guys a quick and easy way to hide social security numbers when youamp;#39;re working with a document. There may be time when the Social Security Number is actually helpful and you just want to leave the last four numbers. So weamp;#39;re going to act like youamp;#39;re provide with this list and you are going to change it over to this list on the right. Weamp;#39;ll start from scratch. Take you list here. You can leave it for now. Make a new column. Weamp;#39;ll just call this amp;quot;maskedamp;quot;. Since youamp;#39;re masking the SSNs. You want to use a function called CONCAT. Which means to join things together. Weamp;#39;re going to concatenate first. the last four numbers here with some dummy characters to begin with. Weamp;#39;re going to start the function with an amp;quot;=amp;quot; sign. Start typing CONCATENATE and Google Docs will tell you will suggest which one to use. We just want to use CONCAT. The first valueamp;#39;s goin