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, 2019 at 19:23

1 Answer 1


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 and acknowledge that you have read and understand our privacy policy and code of conduct.

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