I have a column of sentences, and another column of words. most of the sentences contain the the word in the second column. i would like to wrap this word inside {{c1:: }}, because i want to import the spreadsheet into a flashcard app.
This is what the spreadsheet currently looks like:
column 1 | column 2
—————————————————
i like to sing | to sing
this is a pen | pen
i want to eat | want
this is what i want it to look like:
column 1 | column 2
——————————————
i like {{c1::to sing}} | to sing
this is a {{c1::pen}} | pen
i {{c1::want}} to eat | want
How can I do this in libreoffice calc?