How-To Geek on MSN

How to Use the VSTACK and HSTACK Functions in Microsoft Excel

You can use Excel's VSTACK and HSTACK functions to append data in regular cell ranges, Excel tables, or named ranges. into cell E1 stacks the three arrays in the cell ranges A2 to C6, A9 to C13, and ...
HowToGeek on MSN

How to Use the REGEX Functions in Excel

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