Excel Array Formula

How to Count Numbers with Leading Zeros

This post explains that how to count numbers with leading zeros as Text format in excel. How to count numeric format strings with a different number of leading zeros using excel formula. Count Strings with Leading Zeros Suppost you have a list of product ID in your worksheet, and the product ID contains the different… read more »

How to Split Text String to an Array

This post explains that how to convert the text to an Array in excel. How to convert text into array using formula in excel 2013? How to split the text string into an array where the each character in text is an element in array using excel formula in excel 2013. How to split text… read more »

Sidebar