text manipulation Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/text-manipulation/ Bestselling Excel and Power BI Courses Mon, 24 Apr 2023 11:44:52 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png text manipulation Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/text-manipulation/ 32 32 How to Use TEXTBEFORE and TEXTAFTER Functions in Excel https://www.xelplus.com/excel-textbefore-textafter/ Mon, 24 Oct 2022 07:48:00 +0000 https://www.xelplus.com/?p=9211 Learn to properly use the Excel TEXTBEFORE and TEXTAFTER functions. There is a cool trick you can use with these functions to get the outcome you want.

The post How to Use TEXTBEFORE and TEXTAFTER Functions in Excel appeared first on Xelplus - Leila Gharani.

]]> 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.

]]> Combining Data from Multiple Cells – Text and Numbers https://www.xelplus.com/excel-combine-text-number/ Fri, 14 Jan 2022 15:05:00 +0000 https://www.xelplus.com/?p=9575 Learn practical and easy methods (including a hidden tip not many know about) to combine data from multiple cells into a single cell in Excel.

The post Combining Data from Multiple Cells – Text and Numbers appeared first on Xelplus - Leila Gharani.

]]> How to Add Text to Cell values in Excel – Add Text to Beginning or End of Cell values https://www.xelplus.com/excel-add-text-to-values/ Thu, 02 Sep 2021 08:00:00 +0000 https://www.xelplus.com/?p=9825 You can easily add text to your cell values in Excel. You don't have to do this manually. You have 3 easy options to choose from. The 3rd one will surprise you. You can use it in many other circumstances as well.

The post How to Add Text to Cell values in Excel – Add Text to Beginning or End of Cell values appeared first on Xelplus - Leila Gharani.

]]> How to Transform Text with Power Query – Upper Case, Split Text or Format Text Easily https://www.xelplus.com/excel-text-transformation-power-query/ Thu, 11 Jun 2020 09:00:00 +0000 https://www.xelplus.com/?p=11298 Discover the Easiest way to transform text in Excel. Separate words, split cells by delimiter, extract text after space, extract numbers from text and a lot more. Excel Power Query has powerful text transformation options.

The post How to Transform Text with Power Query – Upper Case, Split Text or Format Text Easily appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel’s Amazing Flash Fill https://www.xelplus.com/excel-flash-fill/ Thu, 07 Nov 2019 10:00:00 +0000 https://www.xelplus.com/?p=11790 Excel's Flash Fill feature can save you a ton of time! Check out how you can automatically split names, get the initials, email addresses and more with Excel's amazing Flash Fill feature. No more writing complex formulas.

The post How to Use Excel’s Amazing Flash Fill appeared first on Xelplus - Leila Gharani.

]]>