Thanks for the reply gebobs, but column B is variable. The sequence will not necessarily be the same. For example, row 2 might be 'Lunch', row 3 might be 'Sleep' and that's it in some scenarios. As the variable part of the sentence changes depending on what is selected and in what order, the formula you have suggested won't account for that.