Is there a text function that will concatenate together the contents of a
range, analogous to SUM()?

CONCATENATE() doesn't seem to work on ranges...