#1
|
|||
|
|||
Replacing multiple words at once in excel document
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. |
#2
|
|||
|
|||
You could record a macro that does several find/replace.
|
#3
|
||||
|
||||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find and highlight multiple words in MS Word document | AtaLoss | Word VBA | 37 | 09-22-2021 12:04 PM |
Find and highlight multiple words in a document | flatop | Word VBA | 3 | 04-16-2014 10:29 PM |
Replace words within headers in multiple document | Carchee | Word VBA | 14 | 12-19-2013 04:36 PM |
Replacing a Resource in Multiple Tasks Simultaneously | taffytron | Project | 3 | 12-31-2012 02:21 PM |
Export data from multiple attachments into a single excel document | Woolstar | Outlook | 0 | 12-07-2011 09:49 AM |