J Jeanette Mar 29, 2010 #1 I wanted to know if anyone knew how to remove dashes say from a SS# or a phone number without retyping all the numbers?
I wanted to know if anyone knew how to remove dashes say from a SS# or a phone number without retyping all the numbers?
G Gary''s Student Mar 29, 2010 #2 Say your data is in A1. In another cell: =SUBSTITUTE(A1,"-","") You can then copy this cell and paste/special/value back onto A1
Say your data is in A1. In another cell: =SUBSTITUTE(A1,"-","") You can then copy this cell and paste/special/value back onto A1
