TRIM Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/trim/ Bestselling Excel and Power BI Courses Tue, 19 Dec 2023 15:32:46 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png TRIM Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/trim/ 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.

]]> Top Excel Functions for Engineers https://www.xelplus.com/excel-for-engineers/ Thu, 23 Dec 2021 10:00:00 +0000 https://www.xelplus.com/?p=9605 If you're a Mechanical Engineer, make sure you know these 10 Excel functions. Your work-life will become much easier once you learn these Excel formula combinations.

The post Top Excel Functions for Engineers appeared first on Xelplus - Leila Gharani.

]]> Best 10 Excel Functions for Accountants https://www.xelplus.com/excel-functions-for-accounting/ Thu, 25 Feb 2021 10:00:00 +0000 https://www.xelplus.com/?p=10260 Make sure you know these Excel functions if you work in Accounting, Finance or you are a Data Analyst. They'll make your work life a LOT easier and they work in all Excel versions (such as AGGREGATE, TRIM, ROUND & more)

The post Best 10 Excel Functions for Accountants appeared first on Xelplus - Leila Gharani.

]]> How to Remove Non-breaking Spaces in Excel Data – Get Rid of ALL Stubborn Spaces https://www.xelplus.com/excel-trim-all-spaces/ Thu, 30 Jan 2020 10:00:00 +0000 https://www.xelplus.com/?p=11519 Sometimes the data you copy or import into Excel has stubborn spaces that can't be removed with the TRIM function. You need a different function to remove these nonbreaking spaces. Something that acts like a TRIM ALL function in Excel.

The post How to Remove Non-breaking Spaces in Excel Data – Get Rid of ALL Stubborn Spaces appeared first on Xelplus - Leila Gharani.

]]> How to Change Letter Case in Excel (3 ways including NO Formulas) https://www.xelplus.com/excel-change-case-of-text/ Fri, 05 Apr 2019 20:03:00 +0000 https://www.xelplus.com/?p=12753 Learn 3 ways to quickly change the case of text in Excel. For example, change lower case to upper case or vice versa - or clean up text to proper case. We use formulas, as well as non-formula techniques to get his done. You'll also find a list of free Fonts you can install.

The post How to Change Letter Case in Excel (3 ways including NO Formulas) appeared first on Xelplus - Leila Gharani.

]]>