Extract Numbers from Alphanumeric String

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

05-13-2011, 12:52 AM

OTPM

Windows 7 32bit Extract Numbers from Alphanumeric String

Office 2010 32bit

Expert

Join Date: Apr 2011

Location: West Midlands

Posts: 981

Quote:

Originally Posted by Colin Legg

If the number is always immediately followed by an "F" or an "S", then you could use this formula:

Code:

=LEFT(A1,MIN(SEARCH({"F","S"},A1&"FS")-1))

Hi Colin
Brilliant. It works fine (better than the formula I used that tok me about 2 hours to work out :-)).
Thanks for your help.
Tony

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 05:52 AM.