Monthly Archives: November 2023

Use case of TEXTSPLIT in #Excel 365

Posted on November 29, 2023 by MF

We talked about the new function – TEXTSPLIT in the previous post. Let’s share a use case of myself in this post. From time to time, I receive email with a long list of recipents. Occassionally, I may want to … Continue reading →

Rate this:

Posted in Excel Tips | Leave a comment

Split text with delimiter(s) into columns or rows and even table with TEXTSPLIT in #Excel365

Posted on November 15, 2023 by MF

It’s a common task to split text into columns in Excel. We can do that with “Text to Columns” under Data tab. That’s very handy, however it returns only static result (good for one off task) and could not split … Continue reading →

Rate this:

Posted in Excel 365, Excel Tips, Formula | Tagged , | Leave a comment