Can I search a cell for a value and extract part of content?

I want to test a cell using something like a "substring" looking for 5
characters. If I find a match I want to capture an use the 4 postion numeric
value in another cell. Example: A1 contains "SALES 4567". I want to test
cell A1 for "SALES" and If I find the value "SALES" I want to capture the
numeric value "4567" in cell N1.

Thanks, JOHN

Try in N1:

=IF(ISNUMBER(SEARCH("SALES",A1)),SUBSTITUTE(A1,"SALES","")+0,"")

Replace SEARCH with FIND
if you need the check on the text to be case sensitive
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Leben" <Leben@discussions.microsoft.com> wrote in message
news:FFD8DF10-9CB2-4335-BFFA-D44D70C9B58E@microsoft.com...
> I want to test a cell using something like a "substring" looking for 5
> characters. If I find a match I want to capture an use the 4 postion
numeric
> value in another cell. Example: A1 contains "SALES 4567". I want to
test
> cell A1 for "SALES" and If I find the value "SALES" I want to capture the
> numeric value "4567" in cell N1.
>
> Thanks, JOHN