I use the Concatenate function a lot to group data into a comma deliminated string to paste into various FEA input files.
A simple example is to calculate x,y,z grid coordinates, say (23.4,45.6,78,9) stored in A2:A4 and then produce a string such as:
" GRID,23,23.4,45.6,78,9"
where GRID is...