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

Sub ert()
Dim x, i&, sp
With Range("A1", Cells(Rows.Count, 1).End(xlUp))
    x = .Value
    For i = 1 To UBound(x)
        sp = Split(x(i, 1), ",")
        x(i, 1) = Trim(sp(UBound(sp)))
    Next i
    .Value = x
End With
End Sub

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:

Sub ert()
Dim x, i&, sp
With Range("A1", Cells(Rows.Count, 1).End(xlUp))
    x = .Value
    For i = 1 To UBound(x)
        If InStr(x(i, 1), ",") Then sp = Split(x(i, 1), ","): x(i, 1) = Trim(sp(UBound(sp)))
    Next i
    .Value = x
End With
End Sub