How to use excel concatenate, upper, lower, proper formula?

CONCATENATE() function

This function is used to concatenate multiple columns.

Select all those cells one by one which you want to concatenate. Between two cells if you use double quotation(" ") then you will get space between two values. If you want something like a comma, slash, etc then inside the double quotation write a comma or that thing which you want as a separator.

Formula: =CONCATENATE( cell," ",cell," ",cell...)

Now to apply for other cells just drag it to the end.

UPPER() function

This function is used to change the letter into upper case.

Formula: =UPPER(cell)

Now to apply for other cells just drag it to the end.

LOWER() function

This function is used to change the letter into lower case.

Formula: =LOWER(cell)

Now to apply for other cells just drag it to the end.

PROPER() function

This function makes the first letter of a word capital and keep the remaining letters in the form of lower case.

Formula: =PROPER(cell)

Now to apply for other cells just drag it to the end.