How to extract only numbers from a STRING?

Colin Legg · #1 04-19-2011, 02:43 AM

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

Learner7 · #2 04-19-2011, 03:32 AM

Quote:

Originally Posted by Colin Legg

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

Thanks a lot for your kind help. It is working fine.

Regards.

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