Using ; separator in split function

Hi, so im trying to convert the string “Value1;Value2;Value3” to an array with the split function but im unable to escape the ; character. I can’t change the string because it comes like that from the source. Whenever I put ; , Make things its a parameter separator and not the value im choosing to separate the values.

How can I make this work?

Just copy paste the semicolon from somewhere else, instead of typing in the formula section and it should work after that.

Omg, thank you! Never thought of that.