Skip to content

Chuck Grimmett

Primary Menu

  • About
  • Now
  • Archives
  • What I’m Reading
  • Photography

Tag Excel

Changing the CSV Delimiter and Enclosure Characters on a Mac

January 30, 2018Chuck Grimmett

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

January 29, 2018Chuck Grimmett

TIL how to build JSON strings in Excel with concatenate.

macOS Excel Fill Down Keyboard Shortcut

January 29, 2018Chuck Grimmett

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

August 29, 2016Chuck Grimmett

How to compare data columns of data from different sheets in Excel.

Dealing with Files in AppleScript and Conditional Counts in Excel

March 20, 2016Chuck Grimmett

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

March 10, 2016Chuck Grimmett

TIL how to concatenate columns and convert time in Excel and some more SQL functions.

Summing with Filters in Excel, Reminding Yourself “Why”

March 7, 2016Chuck Grimmett

TIL how to sum in Excel with filters and a trick for bringing myself back in perspective.

I’m on the WordPress.com Special Projects Team at Automattic. I also blog about food and drink at Cook Like Chuck.

  • Peekskill, NY
  • Feed
  • Email
  • Cook Like Chuck
  • Tumblr
  • Keybase
  • GitHub
  • Bl.ocks
  • Flickr
  • Unsplash
  • Instagram
  • LinkedIn
  • Twitter
  • YouTube
  • Quora

Subscribe to new posts

Proudly powered by WordPress and Hosted by Pressable.