Deleting the area code on excel spread sheet phone numbers??
If your phone numbers in A1 a 123 456 7890 or 123-456-7890 or
123.456.7890 or (123) 456-7890 then B1=RIGHT(A1,8) will work.
"Ben" wrote in message
...
Trying to "edit" a spreadsheet of phone numbers so that no area code is
listed. 240 in all, too many to do each one manually.
|