liber office excel make text with variable

 

https://support.office.com/en-za/article/Switch-between-relative-absolute-and-mixed-references-538396b3-990e-4b44-9d9c-28b4151d7d21

 

 

 

http://www.techrepublic.com/article/join-character-strings-with-excels-concatenate-function/