http://www.labnol.org/forums/topic/how-can-i-escape-a-character-in-google-spreadsheets Help Center Topic: How can I escape a character in Google Spreadsheets? en-US Mon, 13 Feb 2012 03:12:06 +0000 http://bbpress.org/?v=1.0.1 q http://www.labnol.org/forums/search.php http://www.labnol.org/forums/topic/how-can-i-escape-a-character-in-google-spreadsheets#post-5720 Sun, 24 May 2009 22:06:53 +0000 Anonymous 5720@http://www.labnol.org/forums/ <p>Thanks - I was looking for this myself.</p> <p><a href="http://ezinearticles.com/?Arrest-Inquiries---What-Can-You-Get-From-an-Online-Arrest-Inquiry-Service&amp;id=2162973" rel="nofollow">Arrest Inquiry</a> </p> <p><a href="http://ezinearticles.com/?Police-Records-Where-Can-I-Find-Free-Police-Records?&amp;id=2255920" rel="nofollow">Police Records</a> </p> http://www.labnol.org/forums/topic/how-can-i-escape-a-character-in-google-spreadsheets#post-5719 Sun, 24 May 2009 16:18:46 +0000 Anonymous 5719@http://www.labnol.org/forums/ <p>I'm getting more feedback (and solutions) here: <a href="http://www.google.com/support/forum/p/Google%20Docs/thread?tid=5ea6ee468ed875a5&amp;hl=en" rel="nofollow">http://www.google.com/support/forum/p/Google%20Docs/thread?tid=5ea6ee468ed875a5&amp;hl=en</a></p> <p>Thanx : ) </p> http://www.labnol.org/forums/topic/how-can-i-escape-a-character-in-google-spreadsheets#post-5715 Sun, 24 May 2009 02:24:39 +0000 Anonymous 5715@http://www.labnol.org/forums/ <p>Hello,</p> <p>Noticed a lot of Google Docs expertise on this website and in this forum, so here it goes....</p> <p>I have a column D as a result from =ImportFeed(A1, "Items", False, 50)<br /> which contains text.</p> <p>Some text in the cell's in D is surrounded by "quotes". I don't want<br /> those quotes, and I want them filtered / stripped / replaced / ...</p> <p>Isn't this possible?</p> <p>I am considering Substitute SUBSTITUTE(text, search_text, new text,<br /> occurrence)<br /> Substitutes new text for old text in a string. Text is the text in<br /> which text segments are to be exchanged. Search_text is the text<br /> segment that is to be replaced (a number of times). New text is the<br /> text that is to replace the text segment. Occurrence (optional)<br /> indicates how many occurrences of the search text are to be replaced.<br /> If this parameter is missing, the search text is replaced throughout.</p> <p>I don't know if I can operate that on my imported output in D, but<br /> nonetheless, First problem is that I cannot escape the character??</p> <p>So I cannot do a search on the quotes in D with:<br /> substitute(*, ") or substitute(*,\") or ???</p> <p>Grumbl - who can help?</p> <p>Thanx!</p> <p>Devvie Nuis</p> <p>Conare nullius momenti videri fortasse missilibus careant<br /> ------<br /> All spelling mistakes are my own and may only be distributed under the<br /> GNU General Public License! – (© 1995-2001 by Coredump; 2002-9 by<br /> DevNullius) </p>