Hi, we have a cell of data from a multi select picklist (the first word is the primary and the second word is the secondary):

For example

Apple; Banana

We need to have 2 columns for primary and secondary.

Is there a way to use a formula to capture the first word before the semi colon and populate the new cell? And then for the word after the semi colon for the new cell in the next column.

Thanks,

Charles