Extract Numbers from Alphanumeric String

		Microsoft Office Forums > Microsoft Excel > Excel
Extract Numbers from Alphanumeric String

FAQ

Thread Tools

Display Modes

05-12-2011, 01:40 AM

OTPM

Windows 7 32bit Extract Numbers from Alphanumeric String

Office 2010 32bit

Expert

Join Date: Apr 2011

Location: West Midlands

Posts: 981

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to extract only numbers from a STRING?	Learner7	Excel	3	07-02-2013 06:25 AM
Can't See Attachments When E-mail String is Saved to PDF	wineattorney	Outlook	1	03-29-2011 02:15 AM
Extract numbers from a text string	aleale97	Excel	4	02-10-2011 10:33 AM
inserting a string of data into an MS Word table???	matto	Word VBA	0	07-16-2010 09:35 AM
Extract from String using Wildcard	whousedmy	Word	0	05-21-2009 01:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:24 PM.