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: January 2013

Switching chunks of cells

January 27, 2013 gexner

When I discussed the updated formulas for extracting two ISBNs in a single column to two other columns, I mentioned that if they weren’t in order and you ended up with the ISBN-13 in the ISBN-10 column, it was easy… Read moreSwitching chunks of cells

Text function: finding sub-text

January 20, 2013 gexner

Sometimes you only care about a certain part of a string of text. For example, when reading a letter from a potential employer the first thing you care about is whether it says to schedule an interview, or to submit… Read moreText function: finding sub-text

Project: Finding files

January 13, 2013 gexner

Note: I planning to follow up last week’s post about the len() function by discussing another text function: find(). Things happened, however, including a friend in the hospital, so I’ll put that off until next week. Instead I’m going to… Read moreProject: Finding files

Text functions: finding length

January 6, 2013 gexner

Last week I said that this week I was going to talk about how to parse variable-format numbers into numbers. Basically, the problem with variable format numbers is that there are important things you don’t know. This is actually true… Read moreText functions: finding length

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