I would like an excel function that will produce a list which concatenates as follows:
[Title]: [Item 1], [Item 2], [Item 3]. Based on a cell for the title and a named range for all the items in the list.
So a colon and space after the title. A comma after each item in the named range. And a full stop after the last item in the list.