text transformation Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/text-transformation/ 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 transformation Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/text-transformation/ 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.

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

]]>