+ 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. ?*: 1 or more characters (equivalent to.*: 0 or more characters (equivalent to.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. (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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |