| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Find nth instance of a character in a string
I'm sure I've done this in the past but for the life of me I can't remember
it now. Say I have a string "http://www.theexceladdict.com/tutorials.htm" in cell A1. I want to determine the position of the last "/" (forward slash). The strings won't always contain the same # of "/"s. I need to be able to do this as a formula and also in VBA code. I appreciate your help. -- Have a great day, Francis Hayes (The Excel Addict) http://www.TheExcelAddict.com Helping Average Spreadsheet Users Become Local Spreadsheet Experts |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I compare data in two worksheets to find matching cells? | Excel Discussion (Misc queries) | |||
| Extract hyperlink string from excel cell | Links and Linking in Excel | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Removing ' character from cells | Excel Discussion (Misc queries) | |||
Threaded Mode
