Thank You For  Subscribing / Contacting Us.

We are in this together now! 😊

We have the expertise to assist you 🎓

And the honesty to refer you to another expert where we are unable to.

Twende Kazi

Let Us Connect
Know Someone Who Would Enjoy Our Work? Please Share

When The TRIM Function Doesn’t Work

Invisible characters are a great threat to accurate results when working with texts. Trim functions work well to remove Char(32) [spaces] but not Char(160) [non-break space] characters. The solution to cleaning non-break spaces is using the SUBSTITUTE function....

Jun 2, 2023

How to Lookup Items in a List

Looking up items in a list is easy when we use the COUNTIF function. COUNTIF function returns a count of number of times a criterion appears in a dataset. =COUNTIF(dataset, criterion) For example, in the image below, we are counting if the currencies appear in our...

May 12, 2023
Print Friendly, PDF & Email
Share This