Insert dashes in phone numbers

I have a whole list of phone numbers that have no dashes or spaces. I need to know how to insert dashes after the 3rd and 6th numbers to clean up the formatting

Thanks

An alternative it so simply use custom formatting.

Format > Cells, on the Format tab, select Custom, and use ###-###-####

HTH

Jason

Text to Columns, delineate by fixed width at 3rd and 6th digit. Create a column of dashes between the area code and the first 3, then between the first 3 and last 4. Function _> concatenate _> select the 5 columns. Copy, paste the values.... tada!

Or you can do it the easy way ^

Thanks to all, That worked