UDF for Last One in List in Cell

[Alex20850]

I have a lot of cells in this format: [TABLE="width: 467"]
<tbody>[TR]
[TD="class: xl66, width: 467"]Inquire | Compare | Compare Files[/TD]
[/TR]
</tbody>[/TABLE]

but the number of items in the cell vary.
I only want the last one "Compare Files"

While this list uses |, I would also like to tell the function what divider to use.

 

[Fluff]

How about

Function MySplit(Cl As Range, Optional deLim As String = "|") As String
   MySplit = Trim(Split(Cl, deLim)(UBound(Split(Cl, deLim))))
End Function

Used like
=MySplit(J12) to use | as the delimiter, or
=MySplit(J12,",")

 

[Alex20850]

Works great! Thanks

How about

Function MySplit(Cl As Range, Optional deLim As String = "|") As String
   MySplit = Trim(Split(Cl, deLim)(UBound(Split(Cl, deLim))))
End Function

Used like
=MySplit(J12) to use | as the delimiter, or
=MySplit(J12,",")

 

[Fluff]

You're welcome & thanks for the feedback