click Substitute. A Function Arguments dialog box will appear. The process is explained in method one for the Function Arguments dialog box. Read: How to use the Find and FindB functions in Excel.
In such scenarios, you may use the Find and Replace feature. For the above example, this works as follows: Excel will alert you with the number of replacements made in the entire sheet or the ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback