Recent content by HixonWolf

I understand that, and appreciate Minty's reply. Thanks for your input.

You're correct, it wasn't clear. I wish for it to return just the text between the commas. I'm not sure where you get the fifth comma from though, I didn't give that as an example. my example would return 860-0006 using the excel formula.

Hi, Thanks for your reply but I was hoping to avoid using VBA. I found using something like: Mid([Itm1], InStr([Itm1],",")+1) would return the data after the first comma, but I would want it after the nth comma.

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