If you need to use numbers in a text string you typically need to use either the TEXT function the DOLLAR or the FIXED function. To make it easier we can create our own function.
Learn about the built-in features that allow you to perform What If analysis in Excel.
This is a recording of a live free webinar I ran in April 2025. Over 100 people attended. The average feedback score from more than 70 people was over 90%.
You can download the materials at the link below the video.
Excel What If Techniques 10/10 I always find your webinars and materials easy to follow and informative. Thank you for continuing to provide the suite of free sessions. N Williams
A recent update to Excel includes a new TRANSLATE function. This function enables you to translate words from one language to another.
Time spent on a hobby feels like time well spent. Obstacles and setbacks aren’t a tragedy, they’re simply part of journey, the things that make it interesting.
I have been going through Mike Girvin’s recent book Microsoft 365 Excel: The Only App That Matters, and found an elegant technique of comparing lists using FILTER and XMATCH. It inspired me to create a custom function to show missing or matching entries.