split text string at 3rd instance of special character from the right of string.

[JRD74]

Hello - trying to find code that will split a text string at the 3rd instance of a special character from the right of the string.

example string - "xxx-yyyy-zzz-FL-1-15-8"

I would like to split the text at the 3rd "-" from the right (split between FL and 1). I then need to paste the 2 values in adjacent cells to the original (using Offset or something).

A1 = xxx-yyyy-zzz-FL-1-15-8
B1 = xxx-yyyy-zzz-FL-
C1 = 1-15-8

there will be varying lengths of text between the dashes, but the split will always be needed at the 3rd "-" from the right.

Any guidance would be appreciated.

 

[Jonmo1]

Welcome to the board

B1: =LEFT(A1,FIND("^",SUBSTITUTE(A1,"-","^",LEN(A1)-LEN(SUBSTITUTE(A1,"-",""))-2)))
C1: =SUBSTITUTE(A1,B1,"")

 

[JRD74]

Thank you Jonmo1. That worked great!