Welcome to another blog post in my Excel #FormulaFriday series. If you're like me, you probably spend a lot of time in Excel working with formulas. And if you're like me, you also probably spend a...
Posts by Barbara
Formula Friday – Add Leading Zeros To Numbers In Excel Using The TEXT Function
Hello Excellers, it is time for some more #FormulaFiday Excel fun. If you need to add leading zeros to a number in Excel, the TEXT function is the way to go. This function converts a text string into...
Macro Mondays -Using An Input Box To Determine Which Excel Rows To Delete.
Hello Excellers, and welcome back. It is time for another instalment in my #MacroMonday, #Excel blog posts in my Excel series. This Macro demonstrates how to use a VBA input box to determine which...
Happy Friday, Excellers, time for more #formulafriday #Excel fun. Today let's look at how to split a cell that contains both text and numbers. When working with data in Excel, there are...
Macro Mondays – Write A Macro To Display A Progress Message In The Status Bar
Hello, Excellers. Bit of a fun Macro today, which is also very useful. If you've ever written a macro in Excel, you know there's no built-in way to display a progress message in the status bar....
Formula Friday – How To See Values And Formulas On The Same Spreadsheet At The Same Time
HDo you ever need to view formulas and values in Excel an spreadsheet at the same time?. For example, maybe you're trying to troubleshoot a formula or curious about how Excel calculates a particular...