Display text from right side of character when there us two the same.

[daza34]

Hi,

I have a cell full of text but also numbers and under scores.

645_OCC Collaborate_3

I have written the below but it displays the text after the first _ and i need it to show the text/number after the last _

=MID(K2:K38272,FIND("_",K2:K38272),200)

I hope this is possible and any help would be appreciated

 

[daza34]

Worked, Thank you very much

 

[Fluff]

Glad we could help & thanks for the feedback