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

Jim Thomlinson


"mark kubicki" wrote:

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