Thread: Extract numbers from a text string
View Single Post
 
Old 02-10-2011, 09:31 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
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
Reply With Quote