Appending records from different data sets into a single list or data range can be tedious if you’re doing it manually. Instead, use Microsoft Excel’s VSTACK() function.

This guide provides step-by-step instructions with examples how to extract a substring in Excel using various text functions.