Bulk Find and Replace in Excel?

[Jon_Hurtado]

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.  

[#2]

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

[#3]

@Jon_Hurtado 

Power Query could do the job replacing all values or parts of the texts at once using existing mapping. Details depend on concrete files.

[#4]

@Jon_Hurtado 

Chandoo did a blog post on this just yesterday. 

[#5]

@Detlef Lewin 

Interesting, one more interpretation of this trick. But I'd prefer more simple variant, don't know who was the author.