Find and remove all text to the left of last comma (including comma) in a cell

Hi Guys,

I need help in removing all text to the left of last comma (including comma) in a cell. I have a column in a spreadsheet with text separated by either one or multiple commas. I need to remove all the text untill the last comma in the cell.

Below is the example:

From "text1, text2, text3, text4" in a cell To just "text4".

Can someone help me with this.

Let me know if any additional information is required.


Best Regards

Hi Excelrookie_1,
maybe something like this

Please Login or Register  to view this content.

Hi Nilem,

I'm getting Compile error: Expected array in line 6 of the above code

x(i, 1) = Trim(sp(UBound(sp)))

Please help

try to change this:

Please Login or Register  to view this content.