Format ph. numbers in .CSV file to take out ( ) so look same
$30-250 USD
Cancelled
Posted over 13 years ago
$30-250 USD
Paid on delivery
Some of the numbers in my csv file with only phone numbers look like;
"(111)--111-1111"
and some look like;
"111-111-1111"
Well the software I am uploading the csv phone number file data into requires that the phone numbers are all the same format.
Is there a command or function or rule format we can tell the .CSV document to follow to get all the lines to follow the same format style so I can succesfully upload my files to my software?
Thank u for trying to help,
Barry
You can do it manually -- which isn't too much hassle. Or I can do some VBA code for you to format the numbers on CSV file open (fully automated) or by a click of a button. Regards, Svet.