UDF for Last One in List in Cell

[Alex20850]

I have a lot of cells in this format:

Inquire | Compare | Compare Files

<tbody>
</tbody>

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