May 15 2020 09:15 AM
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.
May 15 2020 09:48 AM
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
May 15 2020 10:10 AM
Power Query could do the job replacing all values or parts of the texts at once using existing mapping. Details depend on concrete files.
May 15 2020 11:00 AM
May 15 2020 11:43 AM
Interesting, one more interpretation of this trick. But I'd prefer more simple variant, don't know who was the author.