Search results

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...