how to use SEARCH?

H

hendersson

Could someone please tell me how to use the function SEARCH in XL? I
tried the exampel in help, but it doesn´t work =((((((((
 
D

DeanO

Place formulae in cell A1 : =SEARCH("a",C1,1)
Cell C1 contains Dave
Cell A1 returns 2 as the 2nd letter of c2 is "a". Search finds first match
and returns position of match starting at position of third parameter (e.g. 1
)

If "a" does not appear in C2, A1 returns #value

Hope this helps
 
Top