TEXTBETWEEN function in Excel
Excel has new TEXTBEFORE and TEXTAFTER functions. It doesn’t have a TEXTBETWEEN function. Let’s make one.
(more…)Extract Text Before a Number in Excel
Excel’s new TEXTBEFORE function simplifies extracting text from the left. In this example I share how to extract all the text before a number in a code.
(more…)Excel Dashboards #1 Guidelines & Techniques
In this recording of a live webinar I ran in March 2023 you will learn about guidelines and technique for building dashboards in Excel. Use the button below the video to download the materials. https://vimeo.com/807771690 Download Materials This is the first session is a series of five webinars on Excel dashboards. The other four sessions are paid sessions. In this free session we will focus on chart and dashboard guidelines plus some techniques used to create better dashboards. We will…
Forcing a Spill with the Magic Plus Sign
I posted recently about a technique to force a function to spill if it didn’t spill automatically. I have since learned of a much easier way.
(more…)Excel VBA and the TRUNC Function
Excel has a TRUNC function that truncates numbers. For example =TRUNC(15.75) returns 15. It doesn’t round it just removes the fraction leaving the whole number. Excel VBA does not have the TRUNC function. It does have the Fix function that works the same.
(more…)