Formulas that keep your characters in line

-:Formulas that keep your characters in line:-

Description	Formula
Takes only the characters the designated amount when moving from the left	=LEFT( [cell], [number of characters] )
Takes only the characters the designated amount when moving from the right	=RIGHT( [cell], [number of characters] )
Takes only the characters from the designated character moving from the left	=MID( [cell], [character start number], [number of characters] )
Removes any extra spaces before or after a set of text	=TRIM( [cell] )
Counts the number of characters in a cell	=LEN( [cell] )

Formulas that help with text:-

Description	Formula
Puts all text characters in uppercase	=UPPER( [cell] )
Puts the first text character of each word in uppercase and all subsequent text characters in lowercase	=PROPER( [cell] )
Puts all text characters in lowercase	=LOWER( [cell] )

Comments

Interactive Blogposts

Top 100 Useful Excel Macro [VBA] Codes Examples

Yogendra98.blogpost.com You can automate small as well as heavy tasks with VBA codes. And do you know with the help of macros, you can break all the limitations of Excel which you think Excel has? So today, I have listed some of the useful codes e xamples to help you become more productive in your day to day work. You can use these codes even if you haven't used VBA before that. All you have to do just paste these codes in your VBA editor. These codes will exactly do the same thing which headings are telling you. For your convenience, please follow these steps to add these codes to your workbook. Before you use these codes, make sure you have your developer tab on your Excel ribbon to access VB editor. If you don't have please use these simple steps to activate developer tab . Once you activate developer tab, you can use below steps to paste a VBA code into VB editor. Don't Forget: Make sure to download thi...

29 Incredibly Useful Websites You Wish You Knew Earlier@yogendra

Share Pin it Tweet Share Email There are so many wonderful websites around, and it is difficult to know each and every one of them. The below list provides some of those websites that I find particularly helpful, even though they are not as famous or as prevalent as some of the big names out there. 1. BugMeNot Are you bugged constantly to sign up for websites, even though you do not wish to share your email? If yes, then BugMeNot is for you. Instead of creating new logins, BugMeNot has shared logins across thousands of websites which can be used. . 2. Get Notify This nifty little website tracks whether the emails sent by you were opened and read by the receiver. Moreover, it also provides the recipient’s IP Address, location, browser details, and more. 3. Zero Dollar Movies If you are on a constant lookout of free full length movies, then Zero Dollar movies provides a collection of over 15,000 movies in multipl...

Google

गूगल प्रकार सार्वजनिक उद्मोग इंटरनेट कंप्यूटर सॉफ़्टवेयर स्थापना मेन्लो पार्क, कैलिफ़ोर्निया (4 सितंबर 1998) founder = सर्गेइ ब्रिन लैरी पेज मुख्यालय गूगलप्लेक्स माउंटेन व्यू, कैलिफोर्निया , संयुक्त राज्य अमेरिका क्षेत्र विश्वव्यापी प्रमुख व्यक्ति सुंदर पिचाई (सह-संस्थापक एवं सीईओ) एरिक श्मिट (कार्यकारी अध्यक्ष) सर्गेइ (सह-संस्थापक) उत्पाद गूगल उत्पादों की सूची देखें। राजस्व US$ 29.321 अरब (2010) [1] प्रचालन आय US$ 10.381 अरब (2010) [1] निवल आय US$ 8.505 अरब (2010) [1] कर्मचारी 85,050 (मार्च 31, 2018) [1] सहायक कंपनियाँ यूट्यूब , डबलक्लिक , On2 टेक्नोलॉजीज़ , गूगल वॉयस , पिकनिक (सॉफ़्टवेयर) , आद्वर्क , ऐडमॉब वेबसाइट www.google.com

Yogendra Pratap Mishra

Yogendra Pratap Mishra