Use the search and replace function in Excel
The following article provides detailed instructions for you to use the search and replace function in Excel.
You can customize the addition of a comment to a formula or to a data cell in a spreadsheet by following these steps:
1. Find data feature.
Step 1: Open the Find and Replace dialog box in two ways:
Method 1: Press the key combination Ctrl + H.
Method 2: Go to Home tab -> Editing -> Find & Select -> Find:
Use the search and replace function in Excel Picture 1
Step 2: The Find and Replace dialog box appears -> select the Find tab , enter the search content in the Find What section , for example, here is the search for an employee named Lan -> click Find Next to search in turn. The employee named Lan in box 13 is found first, if it is not the employee you want to search -> click Find Next:
Use the search and replace function in Excel Picture 2
- In case the search text is not in the data table -> the message box appears, click OK:
Use the search and replace function in Excel Picture 3
2. Replace data in Excel.
Step 1: Switch to the Replace tab, enter the following content:
- Find What section: Content to be replaced.
- Replace with: Enter the replacement content.
The example here replaces the employee named Lan with Mai.
Use the search and replace function in Excel Picture 4
Step 2: - Click Replace to replace:
Use the search and replace function in Excel Picture 5
- If you want to replace all employees named Lan, click Replace All -> dialog box displays the total number of replacements -> click OK to close the dialog box:
Use the search and replace function in Excel Picture 6
- If the content is not in the data table, the dialog box appears -> click the OK button to close the dialog box:
Use the search and replace function in Excel Picture 7
The above is a detailed guide on how to use the search and replace function in Excel 2013.
Good luck!
You should read it
- Instructions for searching and replacing in Excel tables
- How to use the FIND and REPLACE functions in Excel?
- Instructions for finding names in Excel
- How to use the Search function in Excel
- How to use Hlookup function on Excel
- Difference between REPLACE and SUBSTITUTE in Microsoft Excel
- How to delete dots in a series of numbers on Excel
- Complete guide to Excel 2016 (Part 10): Use the Find and Replace function
- Instructions for using the Find and Replace functions in Excel
- Use the search and replace function in Word
- How to use the IFS function in Excel 2016
- Save time with these text formatting functions in Microsoft Excel