Formula to extract 3rd string starting from right

[spishowtime]

Hello!
Need help on how to extract the 3rd string starting from right separated by commas.
And also the formula to extract the remaining string starting from left. Kindly check attached.
Thank you!!!

[Sam Capricci]

try this for column C... =MID(A2,LEN(A2)-4,1)
still playing around with col D.

[Sam Capricci]

try this for column D... =IFERROR(LEFT(A2,LEN(A2)-6),"")

[Ghozi Alkatiri]

at B2
=LEFT(TRIM(RIGHT(SUBSTITUTE($A2,",",REPT(" ",LEN($A2))),2*LEN($A2))))

at C2
=LEFT(TRIM(RIGHT(SUBSTITUTE($A2,",",REPT(" ",LEN($A2))),3*LEN($A2))))

at D2
=IFERROR(LEFT($A2,LEN($A2)-6),"")

copy down

[Sam Capricci]

I didn't work on the formula in col B because you had a formula there but if you want that and like Ghozi's formula you can change the one in B2 to this...
=LEFT(TRIM(RIGHT(SUBSTITUTE($A2,",",REPT(" ",LEN($A2))),COLUMN(B$1)*LEN($A2))))
and drag toward the right and it will give you the results you want in col C too.

[spishowtime]

Thanks Sambo! sorry.. for the string value its not always 1 character string e.g.
AA,BB,CC
A,BBB,CCC
AAA,B,CCCCC

[JeteMc]

For column C try: =TRIM(LEFT(RIGHT(SUBSTITUTE(A2,",",REPT(" ",100)),300),100))
For column D try: =IFERROR(LEFT(A2,SEARCH(C2,A2)-2),"")
Let us know if you have any questions.