Hi,
I have a formula in Excel that looks up the nth string after the comma.
=TRIM(MID([@Itm1],FIND("#",SUBSTITUTE([@Itm1],",","#",[@Itm3]))+1,255))
@Itm1 is the source data containing the strings and @Itm3 is the nth string to return.
Example string:
@Itm1...