TEXTSPLIT Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/textsplit/ Bestselling Excel and Power BI Courses Thu, 16 Mar 2023 18:54:57 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png TEXTSPLIT Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/textsplit/ 32 32 How to Properly Use the Excel TEXTSPLIT Function https://www.xelplus.com/excel-textsplit-function/ Thu, 31 Mar 2022 08:00:00 +0000 https://www.xelplus.com/?p=9374 Excel's TEXTSPLIT function can split words into separate cells. You can have multiple delimiters, you just have to know how to define these properly. You can also do amazing things like splitting into columns and rows and internally sorting words.

The post How to Properly Use the Excel TEXTSPLIT Function appeared first on Xelplus - Leila Gharani.

]]> New Excel Functions in Office 365 (VSTACK, TEXTSPLIT, TOCOL, DROP, WRAPCOLS, CHOOSECOLS, TAKE) https://www.xelplus.com/new-excel-functions-vstack-textsplit-tocol/ Thu, 31 Mar 2022 05:20:00 +0000 https://www.xelplus.com/?p=9390 Excel recently released a set of new functions like VSTACK, TEXTSPLIT and TOCOL that will have you looking forward to working with complex files and data because your life just got more exciting (at least mine did!).

The post New Excel Functions in Office 365 (VSTACK, TEXTSPLIT, TOCOL, DROP, WRAPCOLS, CHOOSECOLS, TAKE) appeared first on Xelplus - Leila Gharani.

]]>