This returns "A|B|C". You can also concatenate text in a range of cells and even use a formula to filter the array:

=StringConcat(", ",TRUE,IF(B30:B39>4,C30:C39,""))

This will create a string containing a comma-separated list of all values greater then 4 in the given cell range.

Check out for a lot more useful Excel functions including an and even a function to create (GUIDs). Pearson gets a rating of 5 for their excellent free code.

While it is true that you can do many remarkable things in terms of transforming data using Excel, there are all sorts of transformations, particularly those that involve "live" data from the Internet, that Excel can't do easily.