Text Functions

Text function in excel is basically used to convert the numeric values into a text format with suggested codes. We can use Text functions in multiple ways. To Remove Extra Characters (CLEAN, TRIM); to Convert a text in Upper, Lower or Proper Case (UPPER, LOWER and PROPER); Convert Excel Data Types (TEXT, VALUE, ISNUMBER, NUMBERVALUE); Replacing / Substituting Parts of a Text String (REPLACE and SUBSTITUTE); Cutting & Joining of Text Strings (CONCATENATE, CONCAT {New in Excel 2019 – replaces the Concatenate function}, REPT, LEFT, MID, RIGHT, and TEXTJOIN {New in Excel 2019}); Information Functions (LEND, FIND, SEARCH, EXACT).

Join Our Community List

Community grow with You. * VERIFY & CONFIRM YOUR EMAIL *

Thanks for your interest joining to Advance Excel Forum community.

Fill the Correct Information.

Thanks for your interest joining to Advance Excel Forum community.

Something went wrong.

Join Our Community List

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

We use cookies to ensure that we give you the best experience on our website (by analyzing).  Please see our cookies page for further details or agree by clicking the 'Accept' button.

 

Cookie settings

Below you can choose which kind of cookies you allow on this website. Click on the "Save cookie settings" button to apply your choice.

FunctionalOur website uses functional cookies. These cookies are necessary to let our website work.

AnalyticalOur website uses analytical cookies to make it possible to analyze our website and optimize for the purpose of a.o. the usability.

Social mediaOur website places social media cookies to show you 3rd party content like YouTube and FaceBook. These cookies may track your personal data.

AdvertisingOur website places advertising cookies to show you 3rd party advertisements based on your interests. These cookies may track your personal data.

OtherOur website places 3rd party cookies from other 3rd party services which aren't Analytical, Social media or Advertising.