SUBSTITUTE function - Microsoft Support
This article describes the formula syntax and usage of the SUBSTITUTE function in Microsoft Excel. Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.
REPLACE, REPLACEB functions - Microsoft Support
This article describes the formula syntax and usage of the REPLACE and REPLACEB function in Microsoft Excel. REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string. REPLACEB replaces part of a text string, based on the number of bytes you specify, with a different text string.
Find or replace text and numbers on a worksheet
Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can replace it with something else. You can include wildcard characters such as question marks, tildes, and asterisks, or numbers in your search terms.
Replace values (Power Query) - Microsoft Support
In Power Query, you can replace one value with another value in a selected column. You can replace specific values or the whole value in a cell. Replacing values in a query does not edit the external data source in any way. The default behavior for text values is to search and replace a specific text string. This behavior can be changed.
How to correct a #VALUE! error - Microsoft Support
Sometimes you just want to replace the #VALUE! error with something else like your own text, a zero or a blank cell. In this case you can add the IFERROR function to your formula. IFERROR checks to see if there’s an error, and if so, replaces it with another value of your choice.
SUBSTITUTE function - Microsoft Support
This article describes the formula syntax and usage of the SUBSTITUTE function in Microsoft Excel. Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.
Using wildcard characters in searches - Microsoft Support
Use wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These characters can be the asterisk (*), the question mark (?), and the tilde (~).
Replace a formula with its result - Microsoft Support
If you want to freeze only part of a formula, you can replace only the part you don't want to recalculate. Replacing a formula with its result can be helpful if there are many or complex formulas in the workbook and you want to improve performance by creating static data.
Video: Find and replace text - Microsoft Support
If you’re working with a lot of text and need to search and replace a word or a phrase, use Find and Replace in your Office app. Select Replace or press Ctrl + H.
How to correct a #N/A error in the VLOOKUP function
Solution: You can try to fix this by adjusting your VLOOKUP to reference the correct column. If that’s not possible, then try moving your columns.
Find and remove duplicates - Microsoft Support
How to find and remove duplicates in Excel. Filter for unique values in large or small datasets to clean up your worksheets and workbooks.