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
 

Thread Tools
Display Modes


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 01:22 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