instr() ?

[mark kubicki]

is there an XL or XL/VBA equivalent of the function: INSTR() which returns
the first occurrence of a character within a string?

I've used it in ACCESS/VBA, but can't seem to find it in Excel

thanks in advance,
mark

 

[Don Guillett]

look in vba help index for INSTR

 

[Guest]

In XL there are Find (Case Sensitive) and Search (Not Case Sensitive)... In
VBA you can use InStr...

 

[Guest]

=FIND()

the worksheet function