![]() |
#1
|
|||
|
|||
![]()
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
__________________
Using O365 v2503 - 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 |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
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 |