Select Page

Pulling digits from an alphanumeric string

GOAL: To pull digits from alphanumeric strings. If length and position of numeric data is fixed we can extract digits using built in functions of Excel e.g. LEFT, RIGHT and MID. Our goal is to develop a formula/ function by which we can pull digits from alphanumeric...

Number format in Indian Style

Number format used in India is different from the international style. It’s same up to “Ten thousand” but after that it’s totally different. Have a quick view here below:   To know more about Indian number system please visit:...

Excel Precision and Rounding errors

Excel maintains 15 digits of internal precision; however, we may choose any format of our choice to display the number in the worksheet. Suppose, all the cells in my worksheet are formatted with “comma style”; i.e., it will display only two digits after decimal. Now,...

R1C1 reference style in Excel

Suppose, one day you have started excel as usual but your excel sheet column headers are appearing as 1, 2, 3 instead of A, B, C. Also when you select any cell, in name box excel displaying cell address as R1C1 instead of A1, where R stands for row and C stands for...

Restrict Duplicate Entry in a Data List in Excel

If you are maintaining a data, you may require to ensure a field having unique entries only. Unique Entries, in excel terms, are those entries which are not repeated in a given field; i.e., they have got no duplicates. Today, we will learn, how to restrict duplicate...

Pin It on Pinterest