How to extract only numbers from a STRING?

		Microsoft Office Forums > Microsoft Excel > Excel
How to extract only numbers from a STRING?

04-19-2011, 02:43 AM

Colin Legg Colin Legg is offline

Windows 7 32bit How to extract only numbers from a STRING?

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Hi,

If you can assume that the number will always come at the end, this formula will do it:

Code:

=TRIM(MID(A1,MIN(SEARCH({1,2,3,4,5,6,7,8,9,0},A1&"1235467890")),255))+0

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
Macro or Function to know wether a string is included in a text	Eduardo	Word VBA	5	06-15-2009 01:55 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:38 AM.