Microsoft Office Forums - View Single Post - [Solved] Extract Numbers from Alphanumeric String

Thread: [Solved] Extract Numbers from Alphanumeric String

View Single Post

Old

05-12-2011, 01:40 AM

OTPM

OTPM is offline

OTPM uses Windows 7 32bit

Windows 7 32bit OTPM uses Office 2010 32bit

OTPM uses Office 2010 32bit

Office 2010 32bit

Expert

The original poster

Join Date: Apr 2011

Location: West Midlands

Posts: 981

OTPM is on a distinguished road

Default

Extract Numbers from Alphanumeric String

Hi All
I am looking for a formula that will extract the first number from an alphanumeric string that may have more than one number contained inside the string. For example I want to be able to extract "360" only from the following alphanumeric string:

360FS+6wks

Any help would be appreciated.
Tony

Reply With Quote