Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting characters after 3rd occurence of a string
Trying to systematically delete all characters after the 3rd occurence of a
string and not having much luck with the Len, right and substitute commands. In a region of cells, some of the data contains values separated by the '/' character. when a cell contains the '/' character 3 (or more) times, I'd like to remove that character and all characters to the right of it. Thus: apple/banana/cherry/date would get truncated down to apple/banana/cherry animal/vegetable would remain animal/vefetable thoughts? -- Thanks, Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Leading Characters If String Is Only 7 Characters | Excel Discussion (Misc queries) | |||
SUMIF where CRITERIA is looking for a string occurence in the value,not the whole value | Excel Worksheet Functions | |||
Deleting Characters | Excel Discussion (Misc queries) | |||
How to count occurence of multiple characters in a cell | Excel Worksheet Functions | |||
How to find the first occurence of any number in a string | Excel Programming |