Category: Adv. Excel Text

When dealing with multiple non-contiguous lists, you can first use the VSTACK function to vertically combine the lists into a…

A list can be extended to the right and down using the EXPAND function. You’ll need to come up with a creative solution to add…

With 2 Lists Place Rows 1-2 and Rows 1-2 into a New Single Row (by row) Using the HSTACK or

Use a negative instance_num value to remove or replace the text following the last occurrence of the delimiter…

The TEXTAFTER function in Excel removes or replaces text that follows a given delimiter. When multiple delimiters appear in the…

Use the HSTACK function to combine the data from the lists into a single list if it is horizontally arranged in rows. For instance…

Excel’s CHOOSECOLS function returns selected columns from a list or range. The columns to return are stated in separate…