LEN function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/len-function/ 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 LEN function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/len-function/ 32 32 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.

]]> Use this Excel Trick to Only Count Cells with Text (Exclude Numbers and Blanks) https://www.xelplus.com/excel-formula-hack-count-text/ Thu, 05 Mar 2020 10:00:00 +0000 https://www.xelplus.com/?p=11441 Check out this Excel formula hack to count text cells only. This mysterious syntax excludes blank cells, numbers and also cells with formulas that result in an empty string.

The post Use this Excel Trick to Only Count Cells with Text (Exclude Numbers and Blanks) appeared first on Xelplus - Leila Gharani.

]]> How to Read and Create Barcodes in Excel https://www.xelplus.com/generate-barcodes-excel/ Thu, 06 Feb 2020 10:00:00 +0000 https://www.xelplus.com/?p=11492 Find out how you can generate UPC barcodes in Excel that work! I tested it with a scanner and the Excel barcodes could be scanned. The solution uses a combination of Excel VBA, formulas and conditional formatting.

The post How to Read and Create Barcodes in Excel 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.

]]>