Combining Ctrl + Shift + Arrow keys lets you extend your selection in any direction until Excel hits a blank cell. Start from the top-left corner of your data, try Ctrl + Shift + Right Arrow, then ...
REGEX is a smarter version of Excel's FIND function, which works well for basic lookups. However, REGEX handles more complex scenarios. For instance, if you need to pull phone numbers from messy text, ...