The default behavior of SPLIT is to consider each character of the separator instead of treat it as a whole. That means either you should just use one CHAR(10) or use FALSE for the third parameter. I can come close to explaining the rest of return value that you're seeing. The restult of the split is a date, 11/11/2025, and the number 1 in the next cell. The datevalue for that date is 45972. So using CONCATENATE in the order that you have should output 459721\n\n. I'm not sure where the extra leading 1 is coming from.