Some improvements are token( ) function to handle common cases better.

• Trim ends: Enter into A1 “ aa bb” and use formula Token(A,1) will return aa. In the past, it returned empty

• Date will be treated as string set column A to date with display of MM/dd/yyyy HH:mm:ss. Enter 4/30/2024 09:47:00. It’s aligned right meaning it’s a date. Use formula Token(A,1) in column B will return 4/30/2024. In the past, it will return the Julian Days numeric value. Workaround before Origin 2026. Token(A$, 1) to force A into string.