Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-18-2023, 09:34 PM
laith93 laith93 is offline Replace any UK Words to US words in the entire document Windows 10 Replace any UK Words to US words in the entire document Office 2019
Competent Performer
Replace any UK Words to US words in the entire document
 
Join Date: Jul 2021
Posts: 117
laith93 is on a distinguished road
Default Replace any UK Words to US words in the entire document


Hi,
When I copy some paragraphs from books or websites, they may be written in the UK English language with some differences in spelling such as
colour ----> color, flavour ----> flavor, so these UK words appeared as wrong words in the document (red underline indicator) UK words.docx.
However, I want to convert any UK words to US words in a quick method.
I selected all paragraphs and changed their language to the US language, but not work
I made the US language as default, but also not fixed.
Thanks
Reply With Quote
  #2  
Old 12-18-2023, 11:56 PM
gmayor's Avatar
gmayor gmayor is offline Replace any UK Words to US words in the entire document Windows 10 Replace any UK Words to US words in the entire document Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Changing all the text to US English will apply the proofing language to the text, but it will not change the spelling as you have noted. It will only highlight the words. You would have to list the words and replace them in turn. See Document Batch Processes and the replace text from table option.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 12-22-2023, 12:10 AM
laith93 laith93 is offline Replace any UK Words to US words in the entire document Windows 10 Replace any UK Words to US words in the entire document Office 2019
Competent Performer
Replace any UK Words to US words in the entire document
 
Join Date: Jul 2021
Posts: 117
laith93 is on a distinguished road
Default

Quote:
Originally Posted by gmayor View Post
See Document Batch Processes and the replace text from table option.
Thanks Mr. Graham
Your tool in my mind as the last option, because I don't know all the different spelling US and UK words to put them in your table, so I searched for a quicker method to change all UK words to US words in the easiest way.
However, if I not find a way, of course I will use your tool.
Best Regards
Reply With Quote
  #4  
Old 12-22-2023, 02:35 AM
gmayor's Avatar
gmayor gmayor is offline Replace any UK Words to US words in the entire document Windows 10 Replace any UK Words to US words in the entire document Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

You have identified the problem with this type of issue. You would have to tell any macro what you want to change. There are word lists available on line e.g. https://www.cdnjustlearn.com/public/...s-American.pdf which you could probably use to extract the changes you want to make. The more words you choose to process, the slower that process will be.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #5  
Old 12-25-2023, 01:56 AM
laith93 laith93 is offline Replace any UK Words to US words in the entire document Windows 10 Replace any UK Words to US words in the entire document Office 2019
Competent Performer
Replace any UK Words to US words in the entire document
 
Join Date: Jul 2021
Posts: 117
laith93 is on a distinguished road
Default

Quote:
Originally Posted by gmayor View Post
There are word lists available on line e.g. https://www.cdnjustlearn.com/public/...s-American.pdf
Thanks so much
I will make a table special for the different spelling of US and UK words, then I use your tool "Batch Process".
Thanks
Best Regards
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to stop additional words/paragraphs pushing down the entire document hockeyrobot Word 4 04-24-2023 05:18 PM
How to find (highlight) two and more words in a list of 75k single words in Word 2010 Usora Word 8 05-29-2018 03:34 AM
Replace any UK Words to US words in the entire document Attempting to find text, select words before it, and format the entire selection KeviM Word VBA 1 04-07-2017 05:36 PM
Replace any UK Words to US words in the entire document Replace words within headers in multiple document Carchee Word VBA 14 12-19-2013 04:36 PM
Replace any UK Words to US words in the entire document Macro to replace few words in the document ubns Word VBA 7 08-16-2012 10:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft