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 |
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 |