Libreoffice Calc Tutorial Replace Function Libreoffice 6 Calc

Usage:

Do you need to

Usage: Substitutes new_text for old_text in a text string. Syntax: SUBSTITUTE(text, old_text, new_text, [instance_num])

Usage: proper

Learn

Usage: fixed

Usage: LEN returns the number of characters in a text string. Syntax: LEN(text)

Usage: right

Usage: isblank

Usage: code

Usage: Returns the largest value in a set of values. Syntax: max(number1, [number2], ...)

Usage: lower

Learn

Usage: upper

Demo video of

Usage: Returns the smallest value in a set of values. Syntax: min(number1, [number2], ...)

Video

Usage: char

A brief