Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-23-2014, 05:43 AM
Legaly Legaly is offline Windows 8 Office 2007
Novice
 
Join Date: May 2014
Posts: 1
Legaly is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 05-23-2014, 07:05 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 819
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

You could record a macro that does several find/replace.
Reply With Quote
  #3  
Old 05-23-2014, 08:30 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,937
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and highlight multiple words in MS Word document AtaLoss Word VBA 33 10-10-2017 01:35 AM
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


All times are GMT -7. The time now is 05:10 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft