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...

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 …

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

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 …

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 …

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

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?

Jul 3, 2020 · I need to use a combination of excel formulas in one cell to remove commas, periods, spaces and replace with underscore. Also need to add text after the names (to be …

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 …

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 …