Remove Dashes in SS#, Leave Leading 0 and keep it in TEXT
Mar 18, 2010 · I am trying to remove the dashes in a column full of social security numbers but I also want to leave the preceding "0" if the social begins with such. The...
Removing Parenthesis, spaces and dashes from Phone numbers
Mar 3, 2016 · Re: Removing Parenthesis, spaces and dashes from Phone numbers Can't you re-format them as general? HAve you tried to set general format to all your number? I think i must …
Moving dotted line not going away | MrExcel Message Board
May 11, 2016 · Re: Excel - Moving dotted line not going away Let me provide some backstory on this. The behavior changed for Office 365 customers starting in June 2017. Acting in response …
[SOLVED] Need to remove parenthesis from a phone ... - Excel …
May 28, 2014 · Need to remove parenthesis from a phone number and commas from figures We have a spreadsheet of our customer's info, to send to our collection agency; when we export it …
SSN formatting is dropping zeros | MrExcel Message Board
Apr 2, 2004 · I am trying to remove dashes from 9 digit social security numbers with a SUBSTITUE formula (i.e. =Value(Substitute(A1,"-","")) ),but it drops a zero if it is the first …
Removal of dashes and spaces | MrExcel Message Board
May 28, 2002 · Is there a way to remove dashes and/or spaces from a string of numbers in the same cell? eg. 123456 instead of 12 345-6 thanks
VBA: Use Replace to Remove space, comma, dash from Strings
Dec 19, 2014 · Hi all, I am updating an old macro and trying to use the replace function instead of two nested loops that process every character in the columns to remove all spaces, commas …
Removing dashes in a number/leading zero's disappearing
Nov 15, 2005 · I'm telling Excel to do something and it's not obeying my request. I have the following part numbers setup in a column: 000-12345 010-32343 005-16431 I'm wanting to …
How do I remove the dashes but keep the leading zero - MrExcel
Jul 15, 2015 · I have a column that I have leading zeros and dashes in I want to remove the dashes and keep the leading zeros before 01234-07 want it to be like 0123407
Removing "dashas" from a UPC number | MrExcel Message Board
Feb 20, 2004 · I have a spreadsheet full of UPC numbers (ie, 0-70074-56582-5). Is there a an easy way to remove the dashas and just be left with the number?