find location

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

Guest

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
 
This would also work in excel vba (macro) but for a formula you need FIND or
SEARCH. Look in HELP index.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Permutations andText to column problem 6
Find cells that contain text 5
Find Command 9
Searching a cell for certain contents 6
Instr 2
Search and find all "$" in a string 3
Type Mismatch 0
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1

Back
Top