View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John[_17_] John[_17_] is offline
external usenet poster
 
Posts: 4
Default telephone number format

Hi,
I have a spreadsheet of contacts, over 2000.
The telephone numbers are in the format 09999 999999 or 09999999999

I would like them to be updated to +44(0)9999 999999

How can I accomplish this as a batch update?

Regards

John