Excel Substitute and Replace

Maybe I knew this and had to relearn it, but was momentarily stumped when I needed to do some quick clean up and started to use the replace function. The syntax for it seemed strange:     Turns out what I needed was Substitute. Here’s what the help page says: Substitutes new_text for old_text in […]

Read more "Excel Substitute and Replace"

Closing Out 2014

I’m writing this on Monday as I’ve been thinking about the year and what I’d like to do next year. More than ever I appreciate that plans and lists are important, but so is the ability and willingness to adapt as things change, A once a quarter plan/review has worked reasonably well for me. I […]

Read more "Closing Out 2014"