Microsoft Office Forums - View Single Post - [Solved] Extracting a phone number from a string that contains text and numbers.

Thread: [Solved] Extracting a phone number from a string that contains text and numbers.

View Single Post

Old

06-05-2013, 11:55 AM

Serge 007

Serge 007 is offline

Serge 007 uses Windows XP

Windows XP Serge 007 uses Office 2010 32bit

Serge 007 uses Office 2010 32bit

Office 2010 32bit

Novice

Join Date: Jun 2013

Posts: 6

Serge 007 is on a distinguished road

Default

If still brackets in the text aren't present also number always from 13 signs, it is possible so:

Code:

=mid(a1,find("(",a1),13)

Otherwise - give a file example

Reply With Quote