I need a formula to change a column list of phone #s from example 555-555-5555 to straight #s 15555555555 (adding the 1 and removing the dashes).
This is going to be saved as a CSV (Comma Delimited) file used as an online fax list.
Can you provide me a formala for this?
Thank You.
Bookmarks