I have been shown in the past how to use a built in hot key or function key to make any cell reference in an equation a fixed reference, on the fly. However I have forgotten how and can't find any reference in the help documentation.
So instead of clicking on cell A1 when building an equation...
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...