| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get rest of characters after last certain character?
Hi All,
e.g. In cell A1 there is a string = "dummy1\dummy3\cat\test" In cell B1 I want result = "test" In pseudo code: test = functionX("dummy1\dummy3\cat\test"; "\" ) I don't want write visual basic code just use normal excel functions. Is it possible to write this kind of function? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get characters on left of specified character in Excel | Excel Discussion (Misc queries) | |||
| how to select the first character in a cell and delete the rest | Excel Worksheet Functions | |||
| Extract numeric characters plus one character... | Excel Worksheet Functions | |||
| Counting # of characters before a certain character | Excel Discussion (Misc queries) | |||
| Remove all characters following the first character in a string | Excel Discussion (Misc queries) | |||
Threaded Mode
