Microsoft Office Forums

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 offline Removing Quotes from a Pasted Result Windows 8 Removing Quotes from a Pasted Result Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

? (confused)
Attached Files
File Type: xlsx ConcantenateExample.xlsx (8.3 KB, 8 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 offline Removing Quotes from a Pasted Result Windows 8 Removing Quotes from a Pasted Result Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

@Guineess
Please post a sample sheet with some data showing the problem ( click Go advanced - Manage attachments)
No Pictures please !
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
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, 8 views)
Reply With Quote
  #8  
Old 08-14-2019, 10:54 PM
ArviLaanemets ArviLaanemets is offline Removing Quotes from a Pasted Result Windows 8 Removing Quotes from a Pasted Result Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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 offline Removing Quotes from a Pasted Result Windows 8 Removing Quotes from a Pasted Result Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:18 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