| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Location of the last "s" in a text string
I've got a cell with some text in it.
Example - A1 has the text "This is a test" I'm trying to come up with a formula that will tell me the location of the last "s" in this cell. I've tried using a FIND function, but that will only give me the first occurrence starting at whatever position I specify. How can I get the location of the last "s" without knowing a starting position? Thanks, Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove last character of text string | Excel Worksheet Functions | |||
| How to import a text file to Excel treating all input content are in string. | Excel Discussion (Misc queries) | |||
| EXTRACT TEXT FROM TEXT STRING | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Formating a text string? | Excel Discussion (Misc queries) | |||
Threaded Mode
