Where is the Instr() function in Excel 2003?

[Guest]

Previous version of MS Excel had string function called Instr() which
returned the numerical position of a substring. I use it quite frequently but
I can't find it in Microsoft Excel 2003. Was it removed? Why?

The Instr() string function is still in Access 2003, so why wouldn't it
still be in Excel 2003.

Terry H

 

[smw226 via OfficeKB.com]

Hi Chem21

Try:

=Find("Find_String","In_String","Start Number")

Thanks,

Simon

 

[Niek Otten]

Hi Terry,

AFAIK, the Instr() function was available in VBA only, and it still is.
Use the FIND() function in a worksheet

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Previous version of MS Excel had string function called Instr() which
| returned the numerical position of a substring. I use it quite frequently but
| I can't find it in Microsoft Excel 2003. Was it removed? Why?
|
| The Instr() string function is still in Access 2003, so why wouldn't it
| still be in Excel 2003.
|
| Terry H

 

[vezerid]

Terry,
sometimes the Worksheet functions used in Excel have the same name as
those used in VBA (e.g. MID). Sometimes they have slightly different
names (e.g. RAND in Excel, Rnd in VBA). It can also happen that a
symbol is a function in Excel (MOD(5, 2)) and an operator in VBA (e.g.
5 Mod 2)

VBA Instr is served by FIND() and SEARCH(). They have identical syntax.
FIND is case sensitive and SEARCH is case-insensitive.

Does this help?
Kostis Vezerides