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

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

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

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