I need help to divide the question available in cell A1 in Google Sheets using the SPLIT formula with the delimiters "a) ", "b) ", "c) ", "d) ", and "e) ", so that each cell of each of the subsequent columns contains an alternative, as in the example in the image below. Could someone help me, please? Thank you!
I tried using the expression =SPLIT(A1;"a) | b) | c) | d) | e)") and many other variations, but none were efficient for using multiple delimiters.
https://docs.google.com/spreadsheets/d/1U9mDFnPKkGIxUQ7komK5Mzr0MBSITw6B2diNvs0BeE8/edit?usp=sharing
>Solution :
You can use REGEXEXTRACT, like this:
=REGEXEXTRACT(A1,"(.+\?) (a\).+) (b\).+) (c\).+) (d\).+) (e\).+)")