You have a list of cells. You want to add a sequential number before the text in each cell.

This video shows how the DOSE for Excel add-in solves the problem. They actually add the sequential number into the cell. You can specify that the number should be separated from the existing text with a space hyphen space.

Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose