Wondering wrote on Tue, 2 Oct 2007 19:39:36 -0700:

W If your phone numbers in A1 a 123 456 7890 or
123-456-7890
W or 123.456.7890 or (123) 456-7890 then B1=RIGHT(A1,8) will
W work.

W "Ben" wrote in message
W ...
?? 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.

I wonder how long it will be before this question becomes moot?
However, I have no real idea how many places still use 7-digit
phone numbers for local calls and I was surprised to find that
San Francisco was among them.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not