Split text in specific column to other columns

[Tamim_Olayan]

[Justin_Barrett]

Welcome to the community, @Tamim_Olayan! :grinning_face_with_big_eyes: Check out this thread, where I share a solution that can be adapted to your situation fairly easily:

Splitting text to alternate columns separated by ; Formulas

[Screenshot 2021-04-07 at 1.24.42 pm] Hi, I’m trying to formulate so I can split the text in one column (separated by a :wink: into multiple. Please can someone help!