Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-12-2019, 09:20 PM
Guinness Guinness is offline Removing Quotes from a Pasted Result Windows 10 Removing Quotes from a Pasted Result Office 2019
Novice
Removing Quotes from a Pasted Result
 
Join Date: Aug 2019
Location: Deep South
Posts: 16
Guinness is on a distinguished road
Default Removing Quotes from a Pasted Result

I have a large concatenated formula that is leaving quotes when I paste it (anywhere). Is there any way to remove the quotes?



Example: ="Mary"&"had"&"a"&"little"&"lamb"

instead of getting Mary had a little lamb,

I'm getting "Mary had a little lamb"
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Curly Smart Quotes Switch to Straight Smart Quotes in New Chapters TheWriterBloke Word 3 03-29-2019 03:11 AM
Removing Quotes from a Pasted Result One Cell that controlls spread sheet result button to change simple fomula result RAH Excel Programming 5 03-31-2018 04:52 PM
Removing Quotes from a Pasted Result How to replace straight quotes with smart quotes in existing document PABwriter Word 4 05-27-2016 03:36 PM
Changing dumb quotes to smart quotes Reisende Word 2 05-02-2016 08:56 PM
Removing Quotes from a Pasted Result Changing single-quotes to double-quotes Bobosmite Word 5 04-15-2013 06:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:51 AM.


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