Calc

Concatonate

Enter into a cell:

="string1" & 1970 & "string2"

results in:

string11970string2

Sheetname in cell

Use the current Sheetname in a cell

=MID(CELL("filename");FIND("#$";CELL("filename"))+2;LEN(CELL("filename")))