This article describes the formula syntax and usage of the SUBSTITUTE function in Microsoft Excel. The Find and Replace action will now be applied to cell range B3B4. Find value in a range worksheet or workbook.
These operate in exactly the same way as for the Find method statement.
In the Find what box type the wildcard expression. Click the cell that contains the formula. Use the REPLACE function when you want to replace text based on a known location. Find value in a range worksheet or workbook.