Find and Replace in Excel

Learn how to use the Find and Replace feature in Excel. This handy tool can save you a ton of time and is very easy to use.

Please refer to “Find and Select” for a background on how to use this feature.

Open “Find and Replace” located in the home section of the main ribbon.

Findandreplace

We will be using the list below for our example.

Say we want to replace “Dian” with “Larry.” Simply input that you want to find “Dian” and replace her with “Larry”

By using the form below, you can easy replace a name, or several names all at once. You can use the Replace All feature to replace multiple criteria.

Leave a Reply

MONTH Function

The MONTH function in Excel returns the month component of a specified date as a number between 1-12. Syntax: =MONTH(serial_number)

Read More »

CONCAT Function

The Excel CONCAT Function joins a range of cells or individual strings of data. This function was introduced in 2016

Read More »
Scroll to Top