Excel functions in plain English

Counts characters in text.

Removes excess spaces.

Removes non-printable characters.

Converts text to uppercase.

Converts text to lowercase.

Capitalises words in text.

Replaces matching text.

Finds text with case sensitivity.

Finds text without case sensitivity.

Returns text before a delimiter.

Returns text after a delimiter.

Splits text using column and/or row delimiters.

Converts numeric text to a number.

Returns today's date.

Returns current date and time.

Creates a date from year, month, and day.

Extracts the year from a date.

Extracts the month from a date.

Extracts the day of the month.

Shifts a date by months.