Editing spreadsheet is fast and simple using DocHub. Skip installing software to your PC and make adjustments using our drag and drop document editor in just a few fast steps. DocHub is more than just a PDF editor. Users praise it for its ease of use and robust capabilities that you can use on desktop and mobile devices. You can annotate documents, make fillable forms, use eSignatures, and send documents for completion to other people. All of this, combined with a competing cost, makes DocHub the ideal choice to strike out card number in spreadsheet files with ease.
Make your next tasks even easier by turning your documents into reusable templates. Don't worry about the safety of your information, as we securely keep them in the DocHub cloud.
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