I do not find the function for my case

[BorislavAbadjieff]

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.
libre.png

[ve3oat]

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

=IF(test,then,else)

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.

[anon73440385]

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

[BorislavAbadjieff]

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