TRIM, UPPER, LOWER, PROPER, LEFT, RIGHT, MID - Text Functions in MS Excel

preview_player
Показать описание

Trim : Trim function is used to remove the extra spaces from the start and end of the cell value. This is quite useful when in a column we have the same values and but some of the cells contain the extra spaces.

UPPER : The UPPER function allows us to convert text to all uppercase (All Capital).

LOWER : The LOWER function allows us to convert text to all lowercase (All Small)

PROPER : The PROPER function allows us to convert text to Proper format (First Letter of Each Word Capital)

LEFT function. LEFT function in Excel is used to return the specified number of characters from start of a string.

RIGHT function. RIGHT function in Excel is used to return specified number of characters from the end of string.

MID function. MID function in Excel is used to return the characters from the middle of string by giving starting position and length of characters to return.

Best regards,
The Office Crew
By Sachin Tanwar
Рекомендации по теме
Комментарии
Автор

Please do Like, Comment, Share and Subscribe
The Office Crew
Sachin Tanwar

TheOfficeCrew
Автор

Thank you so much sir may you live a long and happy life

zeemalimlivlogs
Автор

Sir 'proper and trim' these options are very helpful.

SatanBaghel-myhp
Автор

"Wow, your video on Excel formulas was very helpful! Thanks for sharing your knowledge.

ankitbhati
Автор

Thank you for making this video, it's really helpful .

guddikumari
Автор

Thank you sir very very helpful video🎉🎉🎉🎉🎉

sanjuyadav
Автор

How we can fix the character problem on left for each and every one full name

Rikyshakivines
Автор

What about first mid and last name if we want in capital later and only first later in capital of the full name.

muhammadkhalil
Автор

how to use left/right if the sentence is not symmetrical i.e not equal number of words

akarshanprakash
Автор

1. Ab purane sheet Wale data ka kya hoga, kyuki woh delete kar denge toh Naya data bhi delete hoga.
2. Ab hum ye chahte hai ki nayi sheet me hum aage hi bhi data add kare woh automatically formula wise pic karle.

RathoreShailu