This video goes over a few functions that can help with checking or finding specific text in a cell.
Using VLOOKUP video tutorial:
• How to use VLOOKUP in LibreOffice Calc
For further info, here are official help pages:
Using the Find Function
https://help.libreoffice.org/latest/e...
Using the Search Function
https://help.libreoffice.org/latest/e...
Using the Match Function
https://help.libreoffice.org/latest/e...
Using the VLOOKUP Function
https://help.libreoffice.org/latest/e...