Re: find location

From: Don Guillett (donaldb_at_281.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 15:20:10 -0500

This would also work in excel vba (macro) but for a formula you need FIND or
SEARCH. Look in HELP index. 

-- 
Don Guillett
SalesAid Software
donaldb@281.com
"Ed" <Ed@discussions.microsoft.com> wrote in message
news:1C7B4602-33BD-4389-B048-4A26A5F9FD69@microsoft.com...
> sorry for this stupid question,
> what is the command to put in the cell to find the location of a
string....
>         Column A
> e.g.  Mary, John           =instr(A1, ",")       i want the answer = 5
>        Christine, Peter     =instr(A2, ",")
> = 10
> the above command work in Access/VB but not Excel....
> What is the command for Excel...
> Thanks
> Ed