Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-09-2020, 09:03 AM
Lup Lup is offline Problem when changing single-quotes to double-quotes Windows 10 Problem when changing single-quotes to double-quotes Office 2013
Novice
Problem when changing single-quotes to double-quotes
 
Join Date: Jul 2018
Location: Finland and Spain
Posts: 15
Lup is on a distinguished road
Default Problem when changing single-quotes to double-quotes

When converting a document from British English to American English I ran into the following problem with the quote marks: all attempts to automate the change (Search&Replace or by a Macro) resulted in every opening quote being converted to a closing one!
Manually typing an opening quote works ok.
By doing the S&R conversion as single-quote to TWO double-quotes I got a closing quote-opening quote pair in the document. Deleting the first one (the closing quote) resulted in the remaining one immediately changing from opening to closing.
As the document I'm working with has 470 opening single-quotes I'm not very keen on doing the job one quote-character a time; so all help will be appreciated!
_Lup

Note: LibreOffice did the conversion with no immediate problems. But later the converted document caused Grammarly (A grammar check program) to crash(multiple tries!); so that solution is not viable.

Same problem on to two PCs. HP Envy and Elitebook, 64bit, Windows 10 Pro, Office 365 (64 bit on the Envy and 32 bit on the Elitebook)

Last edited by Lup; 02-09-2020 at 09:14 AM. Reason: Forgot the system info!
Reply With Quote
  #2  
Old 02-09-2020, 08:27 PM
Guessed's Avatar
Guessed Guessed is offline Problem when changing single-quotes to double-quotes Windows 10 Problem when changing single-quotes to double-quotes Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

What happens if you change the language and then do a search and replace to find a quote and replace it with a quote (ie. let the smart quotes option work out the direction of each quote)
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 02-10-2020, 04:34 AM
Lup Lup is offline Problem when changing single-quotes to double-quotes Windows 10 Problem when changing single-quotes to double-quotes Office 2013
Novice
Problem when changing single-quotes to double-quotes
 
Join Date: Jul 2018
Location: Finland and Spain
Posts: 15
Lup is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
What happens if you change the language and then do a search and replace to find a quote and replace it with a quote (ie. let the smart quotes option work out the direction of each quote)
Thanks! Interesting idea, but didn't work.
Maybe it's worth adding that I have the Swedish versions of both Windows and Office.
_Lup
Reply With Quote
  #4  
Old 02-10-2020, 03:37 PM
Guessed's Avatar
Guessed Guessed is offline Problem when changing single-quotes to double-quotes Windows 10 Problem when changing single-quotes to double-quotes Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Are you saying you are converting a single to two doubles?
That is ' to ""

Then you are deleting the first one
That is
"" becomes "

Why the two steps?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #5  
Old 02-11-2020, 01:56 AM
Lup Lup is offline Problem when changing single-quotes to double-quotes Windows 10 Problem when changing single-quotes to double-quotes Office 2013
Novice
Problem when changing single-quotes to double-quotes
 
Join Date: Jul 2018
Location: Finland and Spain
Posts: 15
Lup is on a distinguished road
Default

Naturally I tried a one-to-one conversion first! The one-to-two conversion Was just an experiment to see if anything would change; and interestingly enough, the second character of the pair produced was a correct opening quote!
That was, however, a dead end. Deleting the erroneous first quote character resulted in the second one immediately changing to a closing one.
_Lup
Reply With Quote
  #6  
Old 02-11-2020, 04:32 PM
Guessed's Avatar
Guessed Guessed is offline Problem when changing single-quotes to double-quotes Windows 10 Problem when changing single-quotes to double-quotes Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I don't know anything about the Swedish language.

It looks like when you apply the Swedish language to text, Microsoft have configured the software to put all directional quotes in the same closing direction. If I have a paragraph with the spell check in English I get opening and closing quotes (ie two different directions). If I have a paragraph with the spell check in Swedish, all the quotes I get are 'closing' quotes.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #7  
Old 02-11-2020, 11:51 PM
Lup Lup is offline Problem when changing single-quotes to double-quotes Windows 10 Problem when changing single-quotes to double-quotes Office 2013
Novice
Problem when changing single-quotes to double-quotes
 
Join Date: Jul 2018
Location: Finland and Spain
Posts: 15
Lup is on a distinguished road
Default

True, but I have the spell checker set to English and in normal typing, there is no problem.
But, certainly, it's tempting to suspect some interaction from the underlying Swedish Word is the culprit. I'll have a look if changing the display language of Word helps.
_Lup
Reply With Quote
  #8  
Old 02-12-2020, 11:14 AM
Lup Lup is offline Problem when changing single-quotes to double-quotes Windows 10 Problem when changing single-quotes to double-quotes Office 2013
Novice
Problem when changing single-quotes to double-quotes
 
Join Date: Jul 2018
Location: Finland and Spain
Posts: 15
Lup is on a distinguished road
Default

No, changing over to English as Word display language made no difference. But, of course, it's still a "Swedish" version of Office that is the basis...
Guess I'll have to do the conversion "by hand" this time. No fun!
_Lup
Reply With Quote
  #9  
Old 02-12-2020, 01:11 PM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline Problem when changing single-quotes to double-quotes Windows 10 Problem when changing single-quotes to double-quotes Office 2019
Moderator
 
Join Date: Aug 2011
Posts: 3,871
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

The display language in Office shouldn't cause any trouble. I am running a US English installation of Office with Swedish set as the default proofing language.
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
  #10  
Old 02-12-2020, 05:34 PM
Lup Lup is offline Problem when changing single-quotes to double-quotes Windows 10 Problem when changing single-quotes to double-quotes Office 2013
Novice
Problem when changing single-quotes to double-quotes
 
Join Date: Jul 2018
Location: Finland and Spain
Posts: 15
Lup is on a distinguished road
Default

The problem is that I have exactly the opposite set-up! Swedish installation with English set as the proofing language!
On the 64 bit installation, I could change the display langue of Word so it looked like an English version, but that didn't help. I guess there is some difference in the internal logic between the English and Swedish versions and that logic stays unchanged when you change the display language. But that's pure guessing!
_Lup
Reply With Quote
  #11  
Old 02-12-2020, 07:44 PM
Guessed's Avatar
Guessed Guessed is offline Problem when changing single-quotes to double-quotes Windows 10 Problem when changing single-quotes to double-quotes Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

And I suppose changing to dumb (non-directional) quotes is out of the question?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #12  
Old 02-13-2020, 03:16 AM
Lup Lup is offline Problem when changing single-quotes to double-quotes Windows 10 Problem when changing single-quotes to double-quotes Office 2013
Novice
Problem when changing single-quotes to double-quotes
 
Join Date: Jul 2018
Location: Finland and Spain
Posts: 15
Lup is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
And I suppose changing to dumb (non-directional) quotes is out of the question?
No, that's not acceptable.
BUT, your suggestion pointed me the right way!

Here is a way to solve this conundrum:
-First turn off "Straight quotes to smart quotes"
-Then perform the conversion from single to double opening quotes with S&R "Replace all". (Important to copy actual opening single and double quote characters into S&R!)
-Switch "Straigt to Smart" back on
-Perform the conversion for the closing quotes. A bit messy because the need of avoiding genitive and contraction single apostrophes.

Thanks Guessed! You saved my day!
_Lup
Reply With Quote
  #13  
Old 02-13-2020, 04:27 AM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline Problem when changing single-quotes to double-quotes Windows 10 Problem when changing single-quotes to double-quotes Office 2019
Moderator
 
Join Date: Aug 2011
Posts: 3,871
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

Quote:
The problem is that I have exactly the opposite set-up! Swedish installation with English set as the proofing language!
On the 64 bit installation, I could change the display langue of Word so it looked like an English version, but that didn't help. I guess there is some difference in the internal logic between the English and Swedish versions and that logic stays unchanged when you change the display language. But that's pure guessing!
_Lup
But have you tried changing the Windows display language to English, then? That should make it easier for Word to honor the default language setting.
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
  #14  
Old 02-13-2020, 05:15 AM
Lup Lup is offline Problem when changing single-quotes to double-quotes Windows 10 Problem when changing single-quotes to double-quotes Office 2013
Novice
Problem when changing single-quotes to double-quotes
 
Join Date: Jul 2018
Location: Finland and Spain
Posts: 15
Lup is on a distinguished road
Default

Will try, but not today!
_Lup
Reply With Quote
  #15  
Old 02-14-2020, 02:46 AM
Lup Lup is offline Problem when changing single-quotes to double-quotes Windows 10 Problem when changing single-quotes to double-quotes Office 2013
Novice
Problem when changing single-quotes to double-quotes
 
Join Date: Jul 2018
Location: Finland and Spain
Posts: 15
Lup is on a distinguished road
Default

Quote:
Originally Posted by Stefan Blom View Post
But have you tried changing the Windows display language to English, then? That should make it easier for Word to honor the default language setting.
Tried it. Made the problem worse; now it was impossible to create an opening double quote even from the keyboard! Otherwise the same as before.
_Lup
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem when changing single-quotes to double-quotes How to replace straight quotes with smart quotes in existing document PABwriter Word 4 05-27-2016 03:36 PM
Macro to find nested double quotes in document Arg0nawt Word VBA 2 05-03-2016 06:13 PM
Changing dumb quotes to smart quotes Reisende Word 2 05-02-2016 08:56 PM
Problem when changing single-quotes to double-quotes Changing single-quotes to double-quotes Bobosmite Word 5 04-15-2013 06:40 AM
Changing the Double Quotes kosky Word 1 05-24-2012 04:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:09 AM.


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