Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 05-23-2014, 05:43 AM
Legaly Legaly is offline Windows 8 Office 2007
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
Old 05-23-2014, 07:05 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about

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

Alternatively, if there are but few new words, try Ctrl+ H
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Reply With Quote

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 03:13 AM.

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