Split text from a column into 3 or more parts into different columns

[FrancisElliott]

Hi Stephane,

I solved something similar in this post:

Split text using formula and a special character

This is tough, especially with so many instances of your separator. It doesn’t seem like a particularly good use case for monday.com. However… it is possible to achieve. I’d strongly suggest using some helper columns to organize this more effectively: [Screenshot 2023-05-13 at 09.23.16] Second Colon POS formula: SEARCH( ":", RIGHT( {Text}, LEN({Text})-{First Colon POS} ) )+{First Colon POS} Third String formula: LEFT( RIGHT( {Text}, LEN({Te…

Perhaps you can take this approach. Good Luck!