To illustrate the awesomeness of advanced filters, I downloaded an SEMRush organic keyword report for. It would be embarrassing to admit how many times I’ve done that. If you apply a filter of any kind to a formatted table, you can’t put data on either side of it, or you’ll find some of your rows of data disappearing on you. + in regex)Īnother benefit to advanced filters over a table (as much as I love tables) is that you can easily copy your filtered data to another location, which can be really handy.
However, sometimes those filters fall short, especially because Excel doesn’t make the filters sensitive to regex. Okay, let’s cover some basics, so we can get to the cool stuff.įirst of all, if you’re formatting your data as a table, you’ll already have access to quite a few filters.
#Excel regex how to
(If you do want to learn how to leverage regex as a marketer, though, I wrote this post on regex for n00bs last year that makes regex achievable for even the most developer-challenged marketer.) Some Groundwork
And, they’re actually more flexible than regex and much easier to learn. However, as it turns out, Excel offers an alternative to regex that gives you all the same functionality - and is available on all operating systems. (Disclaimer: I’m not affiliated with the SeoTools plugin in any way.) For those of us red-headed stepchildren Mac users, that blows. The SeoTools plugin for Excel supports regex, but it - like most cool resources for Excel - is PC-swim only. Regex allows you to do advanced sorting and filtering. One thing I’ve never understood about Excel is why it doesn’t support regular expressions (which the cool kids call regex).
0 kommentar(er)
