Extracting embeded data from a cell

[DeaninGA]

Hi Everyone,

This one is kicking my tail I need to extract all of the data between the 3rd and 5th commas in a cell.. they arent in the same position every time but they are always between the 3rd and 5th commas. See the highlighted data below

Thanks in advance

VW,CV8SH900,W,20,60,S,ILE3,NJ,NC,NT

 

[sandy666]

with Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    TBD = Table.TransformColumns(Source, {{"Raw", each Text.BetweenDelimiters(_, ",", ",", 2, 1), type text}})
in
    TBD

Raw		Raw
VW,CV8SH900,W,20,60,S,ILE3,NJ,NC,NT		20,60

 

[CA_Punit]

=MID(A1,SEARCH("[",SUBSTITUTE(SUBSTITUTE(A1,",","[",3),",","]",5))+1,SEARCH("]",SUBSTITUTE(SUBSTITUTE(A1,",","[",3),",","]",5))-SEARCH("[",SUBSTITUTE(SUBSTITUTE(A1,",","[",3),",","]",5))-3)

 

[DeaninGA]

THank you both. CA_Punit that worked and im not up on power query

 

[Fluff]

How about
=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A2,",",REPT(" ",100),5),",",REPT(" ",100),3),100,100))