Hello, I wonder is there a way in excel to replace multiple words at once. To have like script where I had all words that need to be replaced and words replacing those. And just click the button and done?
More specifically I'm translating some exports in xls and there are few words repeating over and over again in every document. So for example I need to replace word parfém for perfume like 500 times in one excel document atd..
I think there has to be a easier way to replace those words at once.



Thanks in advance for any help.

You could record a macro that does several find/replace.

Alternatively, if there are but few new words, try Ctrl+ H

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post