Quote:
Originally Posted by Colin Legg
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))
|
Hi Colin
Brilliant. It works fine (better than the formula I used that tok me about 2 hours to work out :-)).
Thanks for your help.
Tony