Excel’s find and replace allows you to search for something (a text, a number, all formulas, etc) and replace it with something else. This blog post gives an entire overview of all options there are when finding and replacing in Excel. Wildcards, removing values, finding line breaks and extra options.
You know most of the ins and outs of Excel. You’re using it to create reports and automate things for yourself or your work. But there is still one thing that you haven’t been able to get into: Visual Basic. Welcome to the advanced lesson on Excel. We’ll be introducing you to the world of … Read more