Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find the last occurance of a character in a cell
I can use the Find function to find the 1st occurance of a charater in
a cell. But, how to i find the last occurence of a character. in this case, the i am looking for " ", or <space. The length of the string can vary, and the number of spaces can vary also. example: "Get dog food 55" There are 14 spaces (1+1+12). i am intersted in the location of the last, or 14th, space, the one that precedes the number 5 Thanks, Tonso |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find first character in cell | Excel Worksheet Functions | |||
Find the next occurance | Excel Worksheet Functions | |||
find a cell with a character | Excel Worksheet Functions | |||
Find the 1st occurance of a number in a cell | Excel Worksheet Functions | |||
Find last occurance of character in text string | Excel Worksheet Functions |