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.
Tag Excel
Building JSON for WPComplete in Excel with Concatenate
TIL how to build JSON strings 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
How to compare data columns of data from different sheets 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
TIL how to concatenate columns and convert time in Excel and some 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.