Formatting Numbers

Copper Contributor


I copied and pasted information to an excel spreadsheet to upload the information on another template. It will not upload correctly because my telephone numbers are not formatted the way the program has them formatted. I need the numbers to go from (555) 555-5555 to 555-555-5555. I am trying to avoid typing all of those numbers. Please advise.  

2 Replies


You can try Flash Fill.

flash fill.JPG

Thank you and can you please tell me how to do it?