Picture of what I am trying to break down

How can I extract just the: Brand, Showroom Only Product, etc.

  • if suggested answers on your questions solved your issues pls accept them – user0 Jul 29 '19 at 19:23

You can use REGEXEXTRACT where you can extract all characters between two known variables. The first variable can be Brand: and the second could be a line break - \n. This would translate into a formula like:

=REGEXEXTRACT(C3, "Brand: (.*)\nShowroom")

Then you could wrap it into ArrayFormula as suggested here: https://webapps.stackexchange.com/a/132303/186471

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.