I have a cell in excel that i pulled off of a website. I write it to excel (for power query purposes) and need to remove most of the text from the beginning. The only constant is one part that says “The respondent”. What is the best way to do this? (In bold is what i need to keep)
Str_var = Letter to Lisa R. Barton, Secretary, USITC; requesting that the Commission conduct an investigation under section 337 of the Tariff Act of 1930, as amended, regarding certain LED lighting devices, LED power supplies, components thereof, and products containing same. The respondent is Current Lighting Solutions, LLC, Beachwood, OH.
Sometimes my String will look like this:
str_var = Letter to Lisa R. Barton, Secretary, USITC; requesting that the Commission conduct an investigation under section 337 of the Tariff Act of 1930, as amended, regarding certain power converter modules and computing systems containing the same. The respondents are Delta Electronics, Inc., Taiwan; Delta Electronics (Americas) Ltd., Fremont, CA; Delta Electronics (USA) Inc., Plano, TX; Cyntec Co., Ltd., Taiwan; Quanta Computer Inc., Taiwan; Quanta Cloud Technology Inc., Taiwan; Quanta Cloud Technology USA LLC, San Jose, CA; Quanta Computer USA Inc., Fremont, CA; Hon Hai Precision Industry Co. Ltd. (d/b/a Foxconn Technology Group), Taiwan; Foxconn Industrial Internet Co. Ltd., China; FII USA Inc. (a/k/a Foxconn Industrial Internet USA Inc.), Milwaukee, WI; Ingrasys Technology Inc., Taiwan; and Ingrasys Technology USA Inc., San Jose, CA.
Any help is appreciated.