Finding all text to the right a the second hyphen

[termeric]

Hello, i'm trying to figure out how to isolate the text to on the right side after the second hyphen. my text string looks like this Category - Name - ID - SubID so i want to only take ID and Sub ID. how can count the number of characters to the right of the second hyphen from the right?

 

[termeric]

so what i want to end up with is
86580531-2612021114547
0838904-2612021134611
143257-261202114184
143257-261202114316

 

[Fluff]

Ok, so some times you will only have two hyphens in the cell, correct?

 

[Rick Rothstein]

Assuming your existing data is in Column A and you want your answers in Column B, give this macro a try...

Sub GetLastTwoDashedNumbers()
  With Range("A2", Cells(Rows.Count, "A").End(xlUp))
    .Offset(, 1) = Evaluate(Replace("IF({1},SUBSTITUTE(@,""-"",""|"",LEN(@)-LEN(SUBSTITUTE(@,""-"",""""))-1))", "@", .Address))
    .Offset(, 1).TextToColumns , xlDelimited, , , False, False, False, False, True, "|", Array(Array(1, 9), Array(2, 2))
  End With
End Sub

 

[termeric]

Ok, so some times you will only have two hyphens in the cell, correct?

correct

 

[Fluff]

Ok, another option

Sub termeric()
   Dim Cl As Range
   
   For Each Cl In Range("A2", Range("A" & Rows.Count).End(xlUp))
      Cl.Offset(, 1).Value = Mid(Cl.Value, InStrRev(Cl.Value, "-", InStrRev(Cl.Value, "-") - 1) + 1)
   Next Cl
End Sub