Formula Friday – How To Count Cells That Contain Text Using COUNTIF
Hello Excellers, welcome to another #Exceltips blog post in my 2021 series. recently I have been counting cells with text in my Excel worksheet. So, I thought it would be a great Excel tip to...
Macro Mondays – Remove Personal Information From Excel Using Some Simple VBA
Hi Excellers, welcome again to some more #macromonday fun. Do you need to share your Excel workbooks?. Do you need to hide the personal information attached to those workbooks.? Well, it is easy to...
Hello, Excellers. Welcome back to another #FormulaFriday Excel tip. Today I will show you how to add emojis to your Excel formulas. Yes, emojis are everywhere. Even in Excel formulas if you...
Macro Mondays – Let’s Compare Absolute And Relative Macro Recording
Hello, Excellers. Welcome to another #MacroMonday for more Macro and coding fun. Today, let's look at a handy topic. First, I will show you the difference between recording an Excel macro...
Hi again, it's Formula Friday yet again. This time, let's look at CONCATENATE in Excel. Now, I always say to users who ask me about concatenate, do not be put off by the long word. It, in essence,...
VBA concatenate macro