Sorry for title, i am really bad at paraphrasing and terms.
I have data in Calc Spreadsheet, lets say column names are “Name, Phone, Adress”.
I want to prepare a text depends on data in my sheet. For example I will choose a name from dropdown and it automatically prepare text as follows:
Hello Dear NAME,
Your message has been sent to phone number PHONE and related document will be posted to this adress: ADRESS
In this text I want to specify its format too, for example boldness, font etc. Because I want to copy this to an email body or printing.
I can do something like ="Hello Dear " & A2
but I cannot change style of cell part and cannot copy to somewhere else. (It copies as table)