| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find cell location in a large list | Excel Discussion (Misc queries) | |||
| How to find out the cell location | Excel Discussion (Misc queries) | |||
| find location max value in column | Excel Discussion (Misc queries) | |||
| How to find the location of a Excel .xla file | Excel Programming | |||
| Find Value in Array and report on Location | Excel Programming | |||
Linear Mode
