Spreadsheet Tricks - Revision history

Dave: /* Google Spreadsheets */ ''Also See: User:Dave/Web_Hack_Notes_(Non-Wiki)#Google_Sheets_as_CMS''

2019-11-18T00:39:55Z

2017-11-29T22:20:20Z

Link To Google Spreadsheets: Link to a cell in a Google Spreadsheet via URL?

2017-11-29T20:46:44Z

Google Spreadsheets: Link To Google Spreadsheets

2016-12-29T20:48:43Z

Miscellaneous Tricks: How to Insert Double or Single Quotes

2016-12-28T22:19:02Z

Miscellaneous Tricks: Add right paran + text color.

2016-12-28T22:12:56Z

Miscellaneous Tricks: extract date from string in excel

2016-09-30T18:31:41Z

Miscellaneous Tricks: How to reverse the concatenate function in Excel?

2016-06-13T20:00:21Z

Google Spreadsheets: Conditional format to a drop down list item in spreadsheet

2016-05-05T22:32:48Z

Miscellaneous Tricks: Insert picture into excel cell

2016-04-25T03:42:18Z

LibreOffice: 'com.mysql.jdbc.driver' cannot be loaded

@@ Line 20: / Line 20: @@
 == Google Spreadsheets ==
 * [http://igoogledrive.blogspot.in/2012/08/conditional-format-to-drop-down-list.html Conditional format to a drop down list item in spreadsheet]
 : Step-by-step guide to conditionally formatting a drop-down list in Google Sheets.

@@ Line 38: / Line 38: @@
 === Link To Google Spreadsheets ===
 * [https://productforums.google.com/forum/#!topic/docs/nYOSkroiHbU;context-place=topicsearchin/docs/authorid$3AAPn2wQcyXHY5Y7svWi8kx9AxKGGK1FnHEiBJEEu1ecbr6j6u484uqU3MMwVK3K1KLSRsACDU5uo4%7Csort:date%7Cspell:false How do I link to a specific tab with Google Sheets?]
 : 2017-11-29: Editor's Note -- Have not tested yet.

@@ Line 36: / Line 36: @@
 * [https://docs.google.com/presentation/d/1HrCFCMh5XxF4JSma_A5-QpAvlyFhpeBzWkZT7CvEsS4/edit#slide=id.p Web Scraping with Google Docs]
 : A powerpoint-like presentation.
 === Fusion Tables ===

@@ Line 110: / Line 110: @@
 :: Extract Path: <tt>=LEFT(A1,MIN(FIND(0,SUBSTITUTE(A1,{1,2,3,4,5,6,7,8,9},0)&0))-1)</tt>
 :: Extract Date: <tt>=SUBSTITUTE(A1,B1,"")</tt>
 * [https://www.extendoffice.com/documents/excel/3278-excel-reverse-concatenate.html How to reverse the concatenate function in Excel?]

@@ Line 107: / Line 107: @@
 === Miscellaneous Tricks ===
 * [http://superuser.com/questions/562659/extract-date-from-string-in-excel extract date from string in excel]
-: For instance, to separate date from full path:<br />(e.g. <tt>Directory\Sub-Directory\12-27-2016</tt> ''to'' <tt>Directory\Sub-Directory\</tt>&nbsp;&nbsp;&nbsp;<tt>12-27-2016</tt>
+: For instance, to separate date from full path:<br />(e.g. <span style="color:blue"><tt>Directory\Sub-Directory\12-27-2016</tt></span> ''to'' <span style="color:blue"><tt>Directory\Sub-Directory\</tt>&nbsp;&nbsp;&nbsp;<tt>12-27-2016</tt></span>)
 :: Extract Path: <tt>=LEFT(A1,MIN(FIND(0,SUBSTITUTE(A1,{1,2,3,4,5,6,7,8,9},0)&0))-1)</tt>
 :: Extract Date: <tt>=SUBSTITUTE(A1,B1,"")</tt>

@@ Line 106: / Line 106: @@
 === Miscellaneous Tricks ===
 * [http://stackoverflow.com/questions/9776611/insert-picture-into-excel-cell Insert picture into excel cell]
 : I can get the pictures to "float" around my worksheet, but I need to put them into a cell. How can I do this?

@@ Line 103: / Line 103: @@
 === Miscellaneous Tricks ===
 ==== Find Common Text Value From Multiple Columns ====
 * [http://superuser.com/questions/811009/excel-how-do-i-find-common-text-values-from-multiple-2-columns Excel- How do I find common text values from multiple (>2) columns?]

@@ Line 6: / Line 6: @@
 * [http://excelforum.com/winner/winner.html Winners of excelforum.com dashboard competition 2014]
 : Winners of 2014 dashboard competition.
 == Google Spreadsheets ==
@@ Line 28: / Line 40: @@
 === Array Formula In Google Spreadsheet ===
 <html><iframe width='950' height='300' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Ap9dh6jmi4yndEp1Q1M4cXk0QTFOTmpRWW5mb25kNkE&output=html&widget=true'></iframe></html><br />
 == [[wikipedia:LibreOffice Calc|LibreOffice Calc]] ==
 * [http://stackoverflow.com/questions/31036760/how-can-i-update-libreoffice-calc-cells-in-real-time-from-a-mysql-database How can I update LibreOffice Calc cells in real-time from a MySQL database?] (StackExchange)
 == Microsoft Excel ==