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 maps Employee ID to computer logon ID.
4 Replies
Interesting, one more interpretation of this trick. But I'd prefer more simple variant, don't know who was the author.
Power Query could do the job replacing all values or parts of the texts at once using existing mapping. Details depend on concrete files.
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
