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 work for …

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 number. How do I get the …

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 puts …

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 and dashes …

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 to this …

Oct 15, 2015 · In my self pondering I was thinking about having the source data pulled into the database unchanged and then either use an update query on the data to remove dashes and add leading …

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?

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 remove the dashes …