Question

explain the built-in functions of ms-excel​

Answer 1

Answer:

Excel Text Functions

Functions to Remove Extra Characters

CLEAN Removes all non-printable characters from a supplied text string

TRIM Removes duplicate spaces, and spaces at the start and end of a text string

Functions to Convert Between Upper & Lower Case

LOWER Converts all characters in a supplied text string to lower case

PROPER Converts all characters in a supplied text string to proper case (i.e. letters that do not follow another letter are upper case and all other characters are lower case)

UPPER Converts all characters in a supplied text string to upper case

And much more.....