Snasui Excel Forum

Hi Dear
I have an issue how to get numbers after each ":" in a cell .
I can write MID , FIND to extract those values but it is not dynamic.
I think about Filterxml function but don't understand this function enough though.
The required outputs are in color cells.

Best Wishes,

Please try at B2

=IFERROR(--MID(SUBSTITUTE($A2,":",REPT(" ",90)),COLUMNS($B2:B2)*180-90,90),"")

or
=IFERROR(FILTERXML("<x><m>"&SUBSTITUTE($A2,":","</m><m>")&"</m></x>","//m["&COLUMNS($B2:B2)*2&"]"),"")

or
=IFERROR(FILTERXML("<x><m>"&SUBSTITUTE($A2,":","</m><m>")&"</m></x>","//m[.>0]["&COLUMNS($B2:B2)&"]"),"")

Thank you so much