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

]]> How to Convert Numbers to Words in Excel https://www.xelplus.com/excel-formula-convert-numbers-to-words/ Thu, 16 May 2019 02:45:00 +0000 https://www.xelplus.com/?p=12345 Use this Excel formula (NO VBA, NO Macros) to convert numbers to words. Download the workbook and copy and paste to your own files. I show you how easily you can adjust the formula to fit your needs.

The post How to Convert Numbers to Words 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.

]]>