Hi. I've read lots of threads about extracting text from a string in a cell (Left, Right, Mid formulas), but I have an outline text string for which I need to extract all of the text AFTER the last period. For example, I may have
1.1.1. Section Coffee (just return Section Coffee)
1.1.12.Section Steeple (just return Section Steeple)
1.19.* Blue Steel (just return Blue Steel)
Depending on the level of the outline, I may need to return the text after the 2nd period or after the 3rd period. Also, sometimes there is a space/spaces after the last period, and sometimes there are none. Thanks!
Frank
Bookmarks