Bulk Find and Replace in Excel?

%3CLINGO-SUB%20id%3D%22lingo-sub-1393323%22%20slang%3D%22en-US%22%3EBulk%20Find%20and%20Replace%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1393323%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20do%20a%20bulk%20find%20and%20replace%20in%20Excel%3F%26nbsp%3B%20We%20have%20well%20over%20700%20instances%20of%20computer%20logon%20IDs%20that%20we%20need%20to%20change%20to%20employee%20IDs%20in%20a%20very%20large%20report.%26nbsp%3B%20We%20have%20a%20CSV%20file%20that%20maps%20Employee%20ID%20to%20computer%20logon%20ID.%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1393323%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1393398%22%20slang%3D%22en-US%22%3ERe%3A%20Bulk%20Find%20and%20Replace%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1393398%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F595296%22%20target%3D%22_blank%22%3E%40Jon_Hurtado%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20want%20each%20change%20to%20reflect%20in%20a%20tabular%20form%20whereby%20you%20can%20list%20out%20the%20changes%20or%20the%20change%20should%20show%20in%20a%20paragraph%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20try%20SUBSTITUTE%20function%2C%20or%20if%20you%20can%20share%20a%20sample%20of%20the%20report%2C%20it%20might%20provide%20more%20insight.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1393464%22%20slang%3D%22en-US%22%3ERe%3A%20Bulk%20Find%20and%20Replace%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1393464%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F595296%22%20target%3D%22_blank%22%3E%40Jon_Hurtado%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPower%20Query%20could%20do%20the%20job%20replacing%20all%20values%20or%20parts%20of%20the%20texts%20at%20once%20using%20existing%20mapping.%20Details%20depend%20on%20concrete%20files.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1393576%22%20slang%3D%22en-US%22%3ERe%3A%20Bulk%20Find%20and%20Replace%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1393576%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F595296%22%20target%3D%22_blank%22%3E%40Jon_Hurtado%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fchandoo.org%2Fwp%2Fmultiple-find-replace-list-accumulate%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EChandoo%20did%20a%20blog%20post%20on%20this%20just%20yesterday.%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1393688%22%20slang%3D%22en-US%22%3ERe%3A%20Bulk%20Find%20and%20Replace%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1393688%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EInteresting%2C%20one%20more%20interpretation%20of%20this%20trick.%20But%20I'd%20prefer%20more%20simple%20variant%2C%20don't%20know%20who%20was%20the%20author.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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
Highlighted

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

Highlighted

@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.

Highlighted
Highlighted

@Detlef Lewin 

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