#1
|
|||
|
|||
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" |
#2
|
|||
|
|||
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.
|
#3
|
|||
|
|||
? (confused)
|
#4
|
|||
|
|||
But when you cut and paste it I get “ “ on either end
|
#5
|
|||
|
|||
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!
|
#6
|
||||
|
||||
@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 |
#7
|
|||
|
|||
I've attached a sample
|
#8
|
|||
|
|||
<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. |
#9
|
|||
|
|||
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.
|
#10
|
|||
|
|||
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! |
|
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 |
One Cell that controlls spread sheet result button to change simple fomula result | RAH | Excel Programming | 5 | 03-31-2018 04:52 PM |
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 |
Changing single-quotes to double-quotes | Bobosmite | Word | 5 | 04-15-2013 06:40 AM |