Hi, I've tried using the search function to find the answer on my own, but I wasn't able to solve my problem.
If someone is able to help me out I'd really appreciate it. I don't know VB so an excel formula is what I really need.
Here is what I want to do. I need to extract
Here is an example:
3M EMI Copper Foil Shielding Tape 1181, 2 in x 18 yd, (50,80 mm x 1,5 m), 5 per case
I need to get the string before the first comma "3M(TM) EMI Copper Foil Shielding Tape 1181".
And also the data after the first comma and before the last comma. Often I can have 4-5 (or more) commas. So I'd need to get " 2 in x 18 yd, (50,80 mm x 1,5 m)" out of that.
Thanks so much!
If someone is able to help me out I'd really appreciate it. I don't know VB so an excel formula is what I really need.
Here is what I want to do. I need to extract
Here is an example:
3M EMI Copper Foil Shielding Tape 1181, 2 in x 18 yd, (50,80 mm x 1,5 m), 5 per case
I need to get the string before the first comma "3M(TM) EMI Copper Foil Shielding Tape 1181".
And also the data after the first comma and before the last comma. Often I can have 4-5 (or more) commas. So I'd need to get " 2 in x 18 yd, (50,80 mm x 1,5 m)" out of that.
Thanks so much!