Extract numbers from a text string

		Microsoft Office Forums > Microsoft Excel > Excel
Extract numbers from a text string

02-10-2011, 09:31 AM

Colin Legg Colin Legg is offline

Windows 7 32bit Extract numbers from a text string

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Welcome to the forum.

If that string is in cell A1 and assuming the number always comes at the end, you could use this formula to extract it:

Code:

=RIGHT(A1,1+LEN(A1)-MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")))

Gives this result:

Code:

9.2.2011

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
inserting a string of data into an MS Word table???	matto	Word VBA	0	07-16-2010 09:35 AM
Text and page numbers in footers?	MikeT1953	Word	0	07-09-2010 08:14 PM
Add text to page numbers	alpruett	Word	0	07-07-2010 09:40 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 07:34 AM.