Microsoft Excel has recently introduced three powerful new functions that leverage regular expressions (REGEX) to enhance text manipulation capabilities.

Not all sorts in Excel are alphabetical. Sometimes, you need to sort by an irregular set of terms, and when that happens, you need to create a custom sort. Here's how.

Thanks to the linked cell property in Microsoft Excel, it's super easy to use the selected value as a condition in a macro or conditional formatting rule.