View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Where is the Instr() function in Excel 2003?

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

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