Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding rightmost location of a character
I have a text string (a directory path actually) that has several "/"
characters in it. I'd like to find the location of the right-most occurrance of an "/". For example, if the string was: "mama/poppa/bogus/dog" .... how do I find the position number of the "/" right before 'dog'? Thanks for any help you can provide! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count occurrence of character within a cell | Excel Discussion (Misc queries) | |||
Return cell contents based on conditional lookup | Excel Worksheet Functions | |||
Finding a character type within a cell | Excel Worksheet Functions | |||
Stock Location Sorting Problem | Excel Discussion (Misc queries) | |||
Add up Plus & Minus Figures separately by Location | Excel Worksheet Functions |