CODEWITHSUNDEEP
google-sheets
Daniel
Daniel

Reputation: 11

Multiple delimiters in SPLIT function, Google Sheets

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!

enter image description here

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

Upvotes: 0

Views: 560

Answers (1)

z..
z..

Reputation: 13013

You can use REGEXEXTRACT, like this:

=REGEXEXTRACT(A1,"(.+\?) (a\).+) (b\).+) (c\).+) (d\).+) (e\).+)")

Upvotes: 1

Related Questions