Counting Characters in Excel

Counting Characters in Excel

For counting the number of characters in single or multiple cells, you may use the Excel LEN function. In the LEN function, you may provide a text string, cell or use LEN with SUM function for counting characters.

Demos and Full Guide
Excel Dropdown List

Excel Dropdown List

In this tutorial, I will show you how to make dropdown list in Excel with examples. Not only will I show you ways of how to create dropdown but how to use its values in different formulas as well.

Demos and Full Guide
Excel Subtract Date Formulas

Excel Subtract Date Formulas

There is a number of ways for calculating the difference between two dates in Excel. You may get the number of days, months and years by using these ways along with adding or subtracting and getting the resultant dates.

Demos and Full Guide
The DATEDIF Function in Excel

The DATEDIF Function in Excel

The Excel DATEDIF function takes the start date, end date, unit and calculates the difference in terms of days, months or years between these two dates. The unit specifies what you require; days, month, or years.

Demos and Full Guide
What are Excel FIND and SEARCH functions?

What are Excel FIND and SEARCH functions?

The FIND is case sensitive to return the position. The ‘C’ and ‘c’ has different meanings if you use FIND method to get the position of text in source string. The SEARCH function is case-insensitive. You may not use the ‘*’ and ‘?’ wildcards in the FIND function.

Demos and Full Guide