Remove and Prevent Automatic Hyperlinks in Excel

  In the past, I highly recommended the Excel newsgroups as a place to go for help. Earlier this month, Microsoft shut down their newsgroup servers, where thousands of people every month had gone to post their Excel questions. Over the past several years, I spent lots of time in those newsgroups, reading and answering…

Questions are often asked in the comments for the Contextures Excel Blog, and sometimes those questions get overlooked, and lost in the shuffle. I’ll post some of the questions here, and please add your suggestions for solving the problems. How Do I Remove Characters? Here is one of those questions, from a commenter named Joanne:…

For your amusement, here’s a word search puzzle that’s filled with the names of Excel worksheet functions. You can work on it at the office, and if anyone asks, just tell them you’re working on some complex Excel functions. Or, print out copies for all of your co-workers, and use it as an ice breaker…

Here’s an Excel question from today’s mailbag. MK asks: I am trying to use countif to find the number of times a word exactly appears in a column – e.g. count the no of times “PACK” appeared in a column excluding “pack” etc. I remember seeing a combination of countif and exact functions used in…