Thread: [Solved] Extract Numbers from Alphanumeric String
View Single Post
 
Old 05-12-2011, 06:51 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
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))
Reply With Quote