Excel Formula Examples

How to Count Spaces before the Text String

This post will guide you how to count the number of spaces before the text string in a cell in Excel. How to count the leading spaces before the text string in one cell with formula in excel. How do I create an excel formula that counts the number of spaces before the text string…. read more »

Count Duplicates

This post will guide you how to count for duplicates in Excel. You will learn how to count the instances of each duplicate value in a column.  You can use the COUNTIF function to count the duplicate values in a column in Excel. If you have a list of data that contain duplicated values in… read more »

How to convert Currencies in Excel

This post will guide you how to convert from a given currency to other specific currencies, such as, how to convert the USD currency to EUR currency. How to convert one currency value to another currency’s value with excel formula. Convert Currency If you want to convert one currency to another, you can write an… read more »

How to Add a Character or Letter before Each Word in a Cell

This post will guide you how to add a specified character or letter before each word in a cell in excel. How to add a character to each word in a cell using excel formula. How to add a hash character before each word with a formula. Add a character or letter before each word… read more »

How to Check If the First Letter is capitalized

This post explains that how to check if the first letter in a cell is capitalized or not in excel. How to write an excel Macro to check if the first letter in a specified cell is capitalized or not. How to test if the first letter in a table cell is capitalized with VBA… read more »

How to Group Time by Hour or Minute

This post will guide you how to group time by hours intervals or group time by minute intervals in excel. How to group time by 3 hours using excel formula? How to group time by 15 minutes with formula in excel. Group Time by Hour or Minute If you have a list of times in… read more »

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 »

Sort Name by Last Name in Excel

This post will guide you how to sort full name by last name in excel. How to sort full names by last name using Text to Columns command in excel. How do I sort names by last name with excel formula. Sort Names by Last Name using Excel Formula Assuming that you have a list… read more »

Sort Names by Middle Name in Excel

This post will guide you how to sort full name by middle name in excel 2013, or 2016. How do I sort names by middle name with excel formula. How to sort full names by middle name using Text to Columns command in excel. Sort Names by Middle Name using Excel Formula Assuming that you… read more »

How to Combine 3 Cells to Generate One Date

This post explains that how to create a date from 3 different cells in excel. How do I combine 3 general cells to one date cell using excel formula. Assuming that you have a list of data that contain three columns of data naming: year, month and day. You want to generate a date from… read more »

Sidebar