|
|
#6
05-12-2011, 06:51 AM
|
||||
|
||||
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))
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to extract only numbers from a STRING? | Learner7 | Excel | 3 | 07-02-2013 06:25 AM |
 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 |
| Extract from String using Wildcard | whousedmy | Word | 0 | 05-21-2009 01:35 AM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode