Forum Discussion
Splitting multiple choice data into separate columns
I have a big data set and one of the columns contains data that was populated from a multiple choice answer on a form where the data came from. The column in question looks something like below. I wa...
Dear Riny_van_Eekelen
I reach out to you to request your support !
As per my Excel sheet attached, could you help me with a formula that can allow me to splitting multiple choice in multiple colomns.
I can get result only for one colomn but i would like to get results for 2 or 3 colomns.
Thank you for your support.
That will be much better if you start new discussion with that question rather than continue quite old thread.
In brief, you may use =ISNUMBER(SEARCH(...)) + ISNUMBER)SEARCH(...))