LibreOffice

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")))

Copy formular to other cells

Source

1. Write formular and confirm with ENTER.
2. Click CTRL + SHIFT + END to select all to the last right cell used on the worksheet. Adjust if necessary.
3. CTRL + D to copy the formular (and adjust the references) to the remaining cells.