Excel Tips - Tip 4 (Change Text using Formulae)

Hello,

Hope my excel tips are helping you out.

Here is the Fourth tip for you. Hope this help you.

To make a report, Text is very Important. So here a tip to change your text according to your need.

·         LOWER( ) - Converts all uppercase letters in a text string to lowercase.

·         UPPER( ) - Converts all lowercase letters in a text string to uppercase.

·         PROPER( ) - Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters. In other words, it converts the string into sentence case.

·         TRIM() -  It help to delete unwanted spaces between a sentence.

·         LEFT() -  It helps to select the text from Left

·         RIGHT() - It helps to select the text from Right

·         MID() – It helps to Select the text from middle

Here are some Examples for the same.

If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:

https://docs.google.com/forms/d/12T8v5XY0XlF9IhuCZPQpydd8hjCtrW7hZs9_GiOffIw/viewform?c=0&w=1

If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Please do share your valuable feedback. Keep Sharing.

Thanks & Regards,

CA Mohit Bansal

Excel Enthusiast

+91-9045773456