I have a Google Spreadsheet where a person will add one name per row in a defined column (B). I need to generate a string like "<p>Adam - Becky - John - Robert</p>
" in one single cell with alphabetically ordered names.
I can sort the names (in the second sheet) with the formula:
=sort(Sheet1!B:B, 1, TRUE)
But how can I concatenate these names in another cell (in the first sheet)?
=sort(Sheet1!B:B)