Find & Replace

How to find and replace multiple values at once in Excel (bulk replace)

How do people usually search in Excel? Mostly, by using the Find & Replace tool, which works just fine for single values. But what if you have tens or even hundreds of items to replace? Luckily, there are a few more effective methods to perform mass replace in Excel, and we are going to look at each of them in detail. Continue reading

How to find and fix broken links in Excel

Excel cells may often link to other workbooks to pull relevant information from there. When a source workbook gets deleted, relocated, or damaged, external references to that file break down and your formulas start returning errors. Obviously, to fix the formulas, you need to find broken links. Continue reading

How to find top or bottom N values in Excel

Want to identify the highest or lowest values in a column or row? Need to return not only the values themselves but their names too? With this tutorial, you will learn how to find top 3, 5, 10 or n values in a dataset and retrieve matching data. Continue reading

Excel wildcard: find and replace wildcards, filter, and use in formulas

When you are looking for something but not exactly sure exactly what, wildcards are a perfect solution. You can think of a wildcard as a joker that can take on any value. There are only 3 wildcard characters in Excel, but they can do so many useful things! Continue reading

Using REPLACE and SUBSTITUTE functions in Excel - formula examples

The tutorial explains the Excel REPLACE and SUBSTITUTE functions with examples of uses. See how to use the REPLACE function with text strings, numbers and dates, and how to nest several REPLACE or SUBSTITUTE functions within one formula. Continue reading

Excel FIND and SEARCH functions with formula examples

The tutorial explains the syntax of the Excel FIND and SEARCH functions and provides formula examples of advanced non-trivial uses. Continue reading

How to use Find and Replace in Excel most efficiently

In this tutorial, you will learn how to use Find and Replace in Excel to search for specific data in a worksheet or workbook and what you can do with those cells after finding them. We will also explore the advanced features of Excel search such as wildcards, finding cells with formulas or specified formatting, find and replace in all open workbooks and more. Continue reading