Where is the Instr() function in Excel 2003?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Hi Chem21

Try:

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

Thanks,

Simon
 
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
 
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
 
Back
Top