Extracting a phone number from a string that contains text and numbers.

		Microsoft Office Forums > Microsoft Excel > Excel
Extracting a phone number from a string that contains text and numbers.

FAQ

Thread Tools

Display Modes

hommi16 Extracting a phone number... 06-05-2013, 09:59 AM

Serge 007 If still brackets in the text... 06-05-2013, 11:55 AM

BobBridges If the only place a left... 06-05-2013, 09:19 PM

06-05-2013, 09:59 AM

hommi16

Windows 7 32bit Extracting a phone number from a string that contains text and numbers.

Office 2007

Novice

Join Date: Jun 2013

Posts: 1

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting Phone Numbers Question	certified_techy	Excel	8	06-08-2012 02:27 AM
Create Custom Labels for Phone numbers	Tonistep	Outlook	0	03-26-2012 02:57 PM
Convert numbers to a specific text string	francis	Excel	1	10-06-2011 01:43 PM
Extract numbers from a text string	aleale97	Excel	4	02-10-2011 10:33 AM
Phone number formatting	Mark Micallef	Outlook	1	08-04-2010 02:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:34 PM.