DocHub is an all-in-one PDF editor that lets you undo social security number in excel, and much more. You can underline, blackout, or remove paperwork elements, insert text and images where you need them, and collect data and signatures. And since it works on any web browser, you won’t need to update your device to access its powerful capabilities, saving you money. When you have DocHub, a web browser is all you need to process your excel.
Sign in to our service and adhere to these instructions:
It couldn't be easier! Streamline your document processing now with DocHub!
how to remove the dashes from an SSN in Excel an SSN stands for social security number and the format is nine digits where each three digits are separated by a dash there may be a situation where you want to remove the dashes so that only the digits are left one easy way to do this well the most obvious way would be used would be to use the find and replace I can press Ctrl f control F opens the find and replace window so here under the replace tab I can say to find The Hyphen and I leave replace with blank meaning that I want to replace the hyphens with blanks and then Iamp;#39;ll say replace all so this says itamp;#39;s done in The mid-12 Replacements Iamp;#39;ll close this now I see that when I use this option this number which had a leading zero has lost the zero so this is incorrect because now this number is wrong so the only way to do that is to use the substitute function in Excel so for that we will need to um add this number in a new column so I will say substitute I can c