Google Spreadsheet Post #1266
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jul 02, 2013
user Anthony Ubelhor (http://productforums.google.com/forum/?zx=aif3093lky7l#!category-topic/docs/spreadsheets/GuksEmNhKOU)
How do I put quotes w/in quotes in a cell formula? (')
'm getting a value error because of the single quote in the name O'Connor.
query(importrange("key","
Is there an equivalent to the html ' that I can insert in this formula?
----------------------------------------------------------------------------------------------------------------------------------------------------
I don't think it is a question on how to insert ' in names ... but rather how to QUERY data that has names containing ' (which is a character that is used in the select option of QUERY operations)
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jul 02, 2013
user Anthony Ubelhor (http://productforums.google.com/forum/?zx=aif3093lky7l#!category-topic/docs/spreadsheets/GuksEmNhKOU)
How do I put quotes w/in quotes in a cell formula? (')
'm getting a value error because of the single quote in the name O'Connor.
query(importrange("key","
Is there an equivalent to the html ' that I can insert in this formula?
----------------------------------------------------------------------------------------------------------------------------------------------------
I don't think it is a question on how to insert ' in names ... but rather how to QUERY data that has names containing ' (which is a character that is used in the select option of QUERY operations)
No comments:
Post a Comment