When you type an email address or website URL in Excel, it might turn into a hyperlink automatically. In the video below, see how you can quickly undo that hyperlink, or stop automatic hyperlinks from happening, with a quick and easy Excel trick. Video: Remove and Prevent Automatic Hyperlinks in Excel This video shows the…
It was Robert Burns Day on Wednesday (January 25th), so I asked ChatGPT to write an Ode to Excel, in the style of Burns’ poem, Address to a Haggis. The results were entertaining, and inspired me to prompt it for an Excel song, in the style of a sea shanty. See if you enjoy the…
Last week, I had fun with a Shakespearean sonnet about Excel problems, written by ChatGPT. So, to keep myself further entertained, I tried a different type of poetry this week – a limerick!
Have you experimented with ChatGPT, to get AI answers to your important questions? I’ve had mixed results, asking ChatGPT to write Excel formulas, and VBA macros. Some responses are good, and others are overly-confident nonsense!
Do you use the CONCATENATE function in Excel, to combine the values from multiple cells? Or are you using the TEXTJOIN function now? If your version of Excel has that function, it’s time to start using it!
If you use Excel at work all day, do you keep using it when you get home? Excel is a great tool for making lists – with or without formulas!
If you use TikTok, have you stumbled across any Microsoft Excel tip videos yet? It’s a fun way to pick up a few new Excel tips and tricks for your spreadsheet toolkit!
Where is Excel headed? On the Forward Thinking CFO podcast, Brian Jones (Head of Product, Excel) discusses Microsoft’s strategy for Excel. There are two 30-minute episodes, and you can listen to both of them below.
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…
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:…
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…
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…