Excel Find - Free Excel Tutorial

Count Cells that are Case Sensitive

If you are a frequent user of Microsoft Excel, you may have come across situations where you needed to add or count the cells that were case-sensitive. If you have done this task manually, I would like to point out that it is the most inefficient way to do it, particularly when MS Excel has… read more »

Abbreviate Names Or Words in Excel

As an MS Excel user, you might have come across a task where you need to abbreviate different names or words, and there are also possibilities that you might have done this task manually by assuming that there isn’t any other way to do this task, but you assumed wrong because fortunately there is a… read more »

Extract Last Two Words From Multiple Cells

Just assume that you have a few cells containing values/words and you want to extract the last two words from each cell into another separate cell; then you might think that it’s not a big deal; because you would prefer to manually extract the last two words from the cell into another without any need… read more »

How to Count Cells that Contain X or Y in Excel

This post will guide you how to count the number of cells that contain X or Y in a given range cells using a formula in Excel 2013/2016.You can easily to count cells equal to a specific value or text string through COUNTIF function. But if there is an easy way to count cells contain… read more »

How to Split Cells by the First Space in Texts in Excel

Sometimes we may use space to separate texts to different groups in one cell, if we want to split this cell to multiple columns refer to space, we can implement this via ‘Text to Columns’ feature. But is there any way to split one cell to only two cells by the first space in the… read more »

How to Remove Middle Name from Full Name in Excel

When we get a list of full names, we can remove the middle name for short in some cases. As the middle names are different among the full name list so we cannot replace them by space directly in excel. This article will provide you two methods to remove the middle name. User can use… read more »

How to Extract Initials From a Name in Excel

This post will guide you how to get initials from a given name using a formula in Excel. How do I extract initials from names in Excel 2013/2016. Extract Initials from a Name Using a Formula Extract Initials from a Name Using User Defined Function Assuming that you have a list of data in range… read more »

How to Remove the First/Last Word from Text string in Cell

This post will guide you how to remove the first and the last word from a text string in cells in Excel. How do I use a formula to remove first and last word of a text string in Excel. Remove the First Word from Text String Remove the Last Word from Text String Remove… read more »

How to Get Text before or after Dash Character in Excel

This post will guide you how to get text before or after dash character in a given cell in Excel. How do I extract text string before or after dash character in Excel. Get Text before Dash Character with Formula Get Text after Dash Character with Formula Get Text Values before and after Dash Character… read more »

Extract Email Address from Text

This post will guide you how to extract email address from a text string in Excel. How do I use a formula to extract email address in Excel. How to extract email address from text string with VBA Macro in Excel. Assuming that you have a list of data in range B1:B5 which contain text… read more »

Get Workbook Path Only

This post will guide you how to get the current workbook path in Excel. How do I insert workbook path only into a cell with a formula in Excel. Get workbook path with Document Location You can get the workbook path from the document location feature, and copy the location to a cell. Do the… read more »

Insert The File Path and Filename into Cell

This post will guide you how to insert the file path and filename into a cell in Excel. Or how to add a file path only in a specified cell with a formula in Excel. Or how to add the current workbook name into a cell in Excel. How do I insert the current worksheet… read more »

List all Worksheet Names

This post will guide you how to get a list of all worksheet names in an excel workbook. How do I List the Sheet names with Formula in Excel. How to generate a list of all sheet tab names using Excel VBA Code. Assuming that you have a workbook that has hundreds of worksheets and… read more »

Reference Tab Name

This post will guide you how to reference a tab name in one cell in Excel. How do I reference a tab name in cell with a formula in Excel. Can anyone tell me the formula on displaying the name of the current worksheet name in a cell on the Sheet. Reference Tab Name with… read more »

Removing Salutation from Name

This post will guide you how to remove salutations from names in the range of cells in excel. How do I remove the salutation from the names cells with formula in Excel. For example, if you have name salutations and you want to remove those salutations from name strings in excel, how to achieve it…. read more »

Sorting IP Address

This post will guide you how to sort IP address in your worksheet. How do I sort IP address with an excel formula. How to sort IP address with Text To Columns feature in excel. Sort IP Address with Formula Assuming that you have an IP list of data in the range of cells B1:B5,… read more »

Quickly Get Sheet Name

This post explains that how to get the sheet name only in your current worksheet in excel. How do I insert the current worksheet’s name into one cell quickly. Get Sheet Name with Formula If you want to quickly get current worksheet name only, then inert it into one cell. You can use a formula… read more »

Split Text and Numbers

This post will guide you how to separate text and numbers from one cell in excel. How do I extract numbers from text string with formulas in Excel. Split Text and Numbers with Formula If you want to split text and numbers from one cell into two different cells, you can use a formula based… read more »

How to Count Cells That Contain Specific Text

This post will discuss that how to count the number of cells that contain specific text or certain text in a specified cells of range in Excel. How to get the total number of cells that contain certain text.  Count Cells That Contain Specific Text Assuming that you have a data of list in range… read more »

Fill Blank Cells with specific value (0 or null)

This post will teach you how to fill all blank cells with specific value, such as: 0 or any other values in excel. How to locate all blank cells and then fill in all the blanks with any specific value. The below will guide you to fill empty cells with different ways in excel 2016… read more »

Sidebar