text functions Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/text-functions/ Bestselling Excel and Power BI Courses Thu, 16 Mar 2023 23:40:16 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png text functions Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/text-functions/ 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.

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

]]>