Hi,
I have text that has multiple delimiter " <" and what I need is to get the text after the last delimiter which is space <, is there any way I can tweak the current formula and to get what I want?
Current Formula is : =TEXTAFTER(P3,"> ",2)
As you see below, the table formula takes the 2nd delimiter but what I need is to get the last text after "<" and sometimes I have 2 and sometime I have more than 2
I have text that has multiple delimiter " <" and what I need is to get the text after the last delimiter which is space <, is there any way I can tweak the current formula and to get what I want?
Current Formula is : =TEXTAFTER(P3,"> ",2)
As you see below, the table formula takes the 2nd delimiter but what I need is to get the last text after "<" and sometimes I have 2 and sometime I have more than 2
Full Reason | Current Formula | Desired Result |
Data Change > Compensation Change Only > Comp Adjustment | Comp Adjustment | Comp Adjustment |
Data Change > Compensation Change Only > Correction | Correction | Correction |
Data Change > Compensation Change Only > Retention | Retention | Retention |
Data Change > Data Change > Data Change > Hours(Full & Part Time) | Hours (Full & Part Time) | Data Change > Hours(Full & Part Time) |
Data Change > Data Change > Data Change > Job Reclassification | Job Reclassification | Data Change > Job Reclassification |
Data Change > Data Change > Data Change > Location | Location | Data Change > Location |
Data Change > Data Change > Data Change > Organization Assignment Changes | Organization Assignment Changes | Data Change > Organization Assignment Changes |