Tag: Excel
-
Changing the CSV Delimiter and Enclosure Characters on a Mac
Read more…: Changing the CSV Delimiter and Enclosure Characters on a MacTIL 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
Read more…: Building JSON for WPComplete in Excel with ConcatenateTIL how to build JSON strings in Excel with concatenate.
-
macOS Excel Fill Down Keyboard Shortcut
Read more…: macOS Excel Fill Down Keyboard ShortcutI 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
Read more…: Comparing Sheet of Data in ExcelHow to compare data columns of data from different sheets in Excel.
-
Dealing with Files in AppleScript and Conditional Counts in Excel
Read more…: Dealing with Files in AppleScript and Conditional Counts in ExcelTIL 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
Read more…: Excel formulas to combine columns and convert time, More SQL functionsTIL how to concatenate columns and convert time in Excel and some more SQL functions.
-
Summing with Filters in Excel, Reminding Yourself “Why”
Read more…: 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.