Microsoft Office Forums Removing Quotes from a Pasted Result

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 08-12-2019, 09:28 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

Also, I need to paste 800+ lines of data into an upload spreadsheet that will upload directly to the web...it does have some html in the string, but I don't think that has anything to do with it because I've had this problem before without the html added. The results will be copy for a product and can't have open and close quotes.
Reply With Quote
  #3  
Old 08-13-2019, 12:56 AM
ArviLaanemets ArviLaanemets is online now Removing Quotes from a Pasted Result Windows 8 Removing Quotes from a Pasted Result Office 2016
Expert
 
Join Date: May 2017
Posts: 464
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough
Default

? (confused)
Attached Files
File Type: xlsx ConcantenateExample.xlsx (8.3 KB, 4 views)
Reply With Quote
  #4  
Old 08-13-2019, 06:38 AM
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

Quote:
Originally Posted by ArviLaanemets View Post
? (confused)
But when you cut and paste it I get on either end
Reply With Quote
  #5  
Old 08-13-2019, 10:46 PM
ArviLaanemets ArviLaanemets is online now Removing Quotes from a Pasted Result Windows 8 Removing Quotes from a Pasted Result Office 2016
Expert
 
Join Date: May 2017
Posts: 464
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough
Default

Quote:
Originally Posted by Guinness View Post
But when you cut and paste it I get on either end
No quotes for me there! I tried both Copy & Paste and Cut & Paste, and either with strings or cell references the result was without quotes always!
Reply With Quote
  #6  
Old 08-14-2019, 12:09 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Removing Quotes from a Pasted Result Windows 7 64bit Removing Quotes from a Pasted Result Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,400
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

@Guineess
Please post a sample sheet with some data showing the problem ( click Go advanced - Manage attachments)
No Pictures please !
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #7  
Old 08-14-2019, 04:32 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

I've attached a sample
Attached Files
File Type: xlsx Example_Microsoft Office Forums.xlsx (45.3 KB, 4 views)
Reply With Quote
  #8  
Old 08-14-2019, 10:54 PM
ArviLaanemets ArviLaanemets is online now Removing Quotes from a Pasted Result Windows 8 Removing Quotes from a Pasted Result Office 2016
Expert
 
Join Date: May 2017
Posts: 464
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough
Default

<Copy this and paste it into a notepad>
(Somehow I can't put any tags into my post!?)

This is not an Excel problem really! It looks like copying the formula result out of Excel/MS Office puts quotes there.


When you replace formulas with values (Copy>PasteSpecial.Values), then the string will be pasted without quotes.
Reply With Quote
  #9  
Old 08-15-2019, 10:05 AM
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

Thanks for your response. Paste special doesn't work in an internet form or notepad. However, I did discover the answer. If you put "Clean" at the beginning of the formula it pulls the beginning and ending quotes out.
Reply With Quote
  #10  
Old 08-15-2019, 10:46 PM
ArviLaanemets ArviLaanemets is online now Removing Quotes from a Pasted Result Windows 8 Removing Quotes from a Pasted Result Office 2016
Expert
 
Join Date: May 2017
Posts: 464
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough
Default

Quote:
Originally Posted by Guinness View Post
Paste special doesn't work in an internet form or notepad.
I didn't mean PasteSpecial into notepad! You use PasteSpecial to put values into Excel (overwriting formulas, or putting values into separate range), and then copy the range with values into notepad.


It looks like CLEAN will work too - this is a function haven't had a need to use jet!
Reply With Quote
Reply

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


All times are GMT -7. The time now is 12:55 AM.


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