We're all familiar with Excel's fill handle: type "Monday," drag the corner, and the rest of the week appears. But there's a hidden gem many people overlook: Custom Lists. Show Excel a pattern once, ...

Regular expressions (or REGEX) are search patterns that can be used to check if a string of text conforms to a given pattern and extract or replace strings of text that match a given pattern. Given ...