ISTEXT Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/istext/ Bestselling Excel and Power BI Courses Thu, 14 Dec 2023 22:28:58 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png ISTEXT Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/istext/ 32 32 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.

]]> Excel Custom Data Validation https://www.xelplus.com/excel-custom-data-validation/ Thu, 24 May 2018 06:49:00 +0000 https://www.xelplus.com/?p=10518 Learn how to create data validation rules with formulas for custom conditions, such as alphanumeric codes or ids that have to follow a specific pattern. With formula, you can check for text, numbers & length of the entered text.

The post Excel Custom Data Validation appeared first on Xelplus - Leila Gharani.

]]>