I do not find the function for my case

I have a work time table with specific characters or numbers and I want to automaticly replace them with text or numbers.
I test few many formulas but no sucsses.

I am not an expert but the format of your function seems to be wrong.


so you need something like =IF(A1=D,“text”,“other text”). If you want the other text to be blank you could try simply “”, or possibly not specify anything for the else part.

Which characters do you want to replace? General hint: Look for REGEX, which has an replacement functionality and was introduced with LibreOffice 6.2.

Thanks a lot, in this way function work. I do not add a blank “” for other text.