Textafter Help

[zinah]

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

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​

 

[Fluff]

Change the 2 to -1

 

[zinah]

Change the 2 to -1

You're the BEST! thanks for the great support and prompt response!

 

[Fluff]

You're welcome & thanks for the feedback.