Forum Discussion
Bulk Find and Replace in Excel?
Is there a way to do a bulk find and replace in Excel? We have well over 700 instances of computer logon IDs that we need to change to employee IDs in a very large report. We have a CSV file that m...
Hi Jon_Hurtado
Do you want each change to reflect in a tabular form whereby you can list out the changes or the change should show in a paragraph?
You can try SUBSTITUTE function, or if you can share a sample of the report, it might provide more insight.
Cheers