-
Changing the CSV Delimiter and Enclosure Characters on a Mac
TIL that you can’t change the CSV delimiter or enclosure characters on Excel for Mac or Apple Numbers. You have to use Open Office.
-
Building JSON for WPComplete in Excel with Concatenate
-
macOS Excel Fill Down Keyboard Shortcut
I never remember the keyboard shortcut for Fill Down in Excel on macOS, so I’m posting it here where I’ll have it. Control + D.
-
Comparing Sheet of Data in Excel
-
Dealing with Files in AppleScript and Conditional Counts in Excel
TIL how to deal with files in AppleScript and how to do conditional counts in Excel.
-
Excel formulas to combine columns and convert time, More SQL functions
-
Summing with Filters in Excel, Reminding Yourself “Why”
TIL how to sum in Excel with filters and a trick for bringing myself back in perspective.