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,...

Gantt chart in Excel with Conditional Formatting

Just try to search out “Gantt Chart” on web once; you will get endless information. If I summarize the same – “Gantt Chart” is a type of bar chart devised by an American engineer and management consultant to represent timeline of different activities of a project....

All about Time in Excel

A number of options are available for adding time in Excel. We may use built-in functions “TIME” or “SUM”, depending on how we have recorded the time in the worksheet. Excel allows us to capture “Hour”, “Minute” and “Second” in separate cells as well as in one too....

Pin It on Pinterest