Skip to content

Swiss Army Spreadsheets

How to do just about anything with software you already have

  • Home
  • About
  • All
  • Author
  • Presentations and Publications
  • Welcome to Swiss Army Spreadsheets

Month: July 2011

When is a spreadsheet not a spreadsheet?

July 31, 2011 gexner

I know that sounds like the opening to a “frayed knot” joke, but I couldn’t come up with a suitable punchline. However, it’s still a valid question that I think it’s time to address. There are two types of data… Read moreWhen is a spreadsheet not a spreadsheet?

Specific functions: Trim

July 24, 2011 gexner

The trim function is a deceptively simple one. All it does is remove excess spaces from a string. However, it makes my list of favorite text manipulation functions because it’s applicable in so many different situations. Like my other favorite… Read moreSpecific functions: Trim

Right, Left, and Middle functions for date handling

July 17, 2011 gexner

As I mentioned before, the right, left, and middle functions can be very useful for handling any sort of formatted data, and one of the simplest forms of formatted data is dates.

Specific functions: Middle

July 10, 2011 gexner

As I mentioned last week, the right, left, and middle functions aren’t very glamorous, but they are workhorses. I often use them together, but not always. They’re useful for date handling, and for interpreting MARC records or any other formatted… Read moreSpecific functions: Middle

Specific functions: Right and Left

July 3, 2011 gexner

The right, left, and middle functions aren’t very glamorous, but they are workhorses. I often use them together, but not always. They’re useful for date handling, and for interpreting MARC records or other formatted data, as well as for proofreading,… Read moreSpecific functions: Right and Left

Recent Posts

  • Working with big data sets: using different functions
  • Working with big data sets: streamlining formulas
  • How big is big?
  • The same but different: conditional formatting in adjacent cells
  • Identifying opening and closing tags

Archives

  • January 2014
  • December 2013
  • November 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010

Categories

  • Uncategorized

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
© 2025 All rights reserved
Proudly powered by WordPress | Theme: Simple Life by Nilambar.
Go to top