find location
 

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

find location
 

Ed

Check out the two functions
FIND() and SEARCH()

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Ed" skrev i en meddelelse
...
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

find location
 

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

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