If your data contains varying delimiters, you can create a custom Google Apps Script to automate the splitting process, or use nested SUBSTITUTE functions to replace all potential delimiters with a consistent one, and then apply the SPLIT function. This preprocessing step ensures that the SPLIT function can be used effectively, regardless of the original data format.