30:00

Proper function
It capitalize first letter of each Word in a cell

Trim function
It delets empty spaces in a cell

Concat function
It joins , combine , bring together words in a one cell

& Function
Work like Concat

=A14&B14&C14

TEXTJOIN Function
Is the easier way to join separate words in a one cell

Right, Left, Mid

Like if you want to take 5 characters from right side
You should write like this
=right(A22,5)

Len function
In another word length

=len(A25)

Find ( case-sensitive) and search ( non case-sensitive) Function

Combing left function with find function

To Find function we give a number of character
And it give us in result till the end of that number of character

True / False function

IF , And, Or function

Ifs function

This function has better advantages

Today function
For Date
=today()

Now function
For Date and time
=now()

CTRL + ~ To Show All the Formulas in the Sheet