Phone Number Formatting

Hey guys,

Thanks for the responses, Please find attached a sample workbook. I left the other columns blank although in my book they are obviouslly full. (There are also 500+ entries as opppsosed to 22)

I've obviously also changed all the phone numbers too but the formats are the same.

Thanks again guys, I appreciate the help.