find location

From: Ed (Ed_at_discussions.microsoft.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 13:03:02 -0700

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

Loading