Thread: [Solved] Extracting a phone number from a string that contains text and numbers.
View Single Post
 
Old 06-05-2013, 09:59 AM
hommi16 hommi16 is offline Windows 7 32bit Office 2007
Novice
  
Join Date: Jun 2013
Posts: 1
hommi16 is on a distinguished road
Default Extracting a phone number from a string that contains text and numbers.
Hi everyone,

I have a whole bunch of cells which contain names, addresses and phone numbers. Each row is varying length and I'm trying to just extract the phone number.

The phone numbers are in this format: (xxx)xxx-xxxx so there are no spaces.

Any help would be appreciated.

Reply With Quote