I need some help to reformat a range of text in a spreadsheet. The text is currently in the following format:
cell A1: "ABCD"
cell B1: "A1 - A5"
I need to convert the range in cell B1 so that the range is expanded downwards in column B. The output should look like this:
A1: "ABCD" B1...