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

look in vba help index for INSTR

--
Don Guillett
SalesAid Software

"mark kubicki" wrote in message
...
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

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

=FIND()

the worksheet function
--
Gary's Student


"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