Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locate and length functions
I am looking for a locate function, WHat I need to do is
find the length of a string up to the first instance of particular character and determine how many characters are before it, then use that result in a left statement something like x=length(string,locate("-")) left(string,x) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to locate the value? | Excel Discussion (Misc queries) | |||
Length that falls within a length interval? | Excel Worksheet Functions | |||
Validation length, Range length | Excel Discussion (Misc queries) | |||
STILL CAN'T LOCATE XML | New Users to Excel | |||
Locate max value cell | Excel Programming |