How can I extract just the: Brand, Showroom Only Product, etc.
0
-
if suggested answers on your questions solved your issues pls accept them – user0 Jul 29 at 19:23
0
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
-
1
-
