The #NULL error occurs when you use an incorrect range operator in a formula or when you use an intersection operator between range references. Here's the fix!

How to Find & Replace Text Parts in MS Excel. Manually finding and replacing parts of text can be exceedingly tedious for lengthy Excel spreadsheets. Luckily, Microsoft included a couple of useful ...

You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.