View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Deleting the area code on excel spread sheet phone numbers??

You'll need to tell us the format of the numbers, and what your rule is for
defining the area code.

In this country there is frequent confusion with people quoting area codes
of 0207 and 0208 when the area code is 020, and similarly quoting 02392 when
it is 023. In the UK, the area code may be 3, 4, 5, or 6 digits (including
the zero at the beginning).
--
David Biddulph

"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.