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?

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

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.

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

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