Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts

Friday, January 14, 2011

Excel Tricks

Reformatting Phone Numbers

To remove the dashes from phone numbers (e.g. change 206-456-789 to 206456789):
=SUBSTITUTE(A1,"-","")
To remove dashes and add digits to the beginning of phone numbers (e.g. change 206-456-789 to 1206456789): NOTE: This should be pretty useful in other situations too and should handle small additions better than creating a new cell/column with what you need to add and then Concatenating everything together. 
=1&SUBSTITUTE(A1,"-","")
Reference