Articles related to excel text functions
Text Functions - Excel's Text Functions - Spreadsheets - About.com
Excel's Text Functions help you manage the text data in your spreadsheets.
Excel LEFT Function - Spreadsheets - About.com
Sep 21, 2007 ... The LEFT function, one of Excel's text functions, is used to remove unwanted characters from the right side of a data entry. This tutorial includes ...
Extract a Substring Using the MID Function in Excel - Spreadsheets
Excel's MID function can be used to extract a substring from a text string containing unwanted characters. This tutorial includes a step by step example of using ...
Convert Case for Text Data with the Excel PROPER Function
The PROPER function is used to convert text data to proper case letters ( combination upper and lower case). A step by step example is included with this tutorial.
Convert Text to Numbers in Excel - Spreadsheets - About.com
How to convert text data to numbers in Excel using the VALUE function. This tutorial contains a step by step example of how to convert text data to numbers in ...
Excel Formulas and Functions - Spreadsheets - About.com
The IF function has also been combined with other popular Excel functions to ... Excel's Text Functions help you manage the text data in your spreadsheets.
Entering Text with the Excel IF Function - Spreadsheets - About.com
Words or text statements can be used with Excel's IF function. This tutorial includes a step by step example of how to use the IF function to enter text into a ...
Excel LOWER Function - One of Excel's TEXT functions
To convert this text all to lower case (small letters) in Excel you can use the LOWER function. The syntax for the LOWER function is: = LOWER ( Text ). Text - the ...
EXCEL VALUE Function Tutorial - Spreadsheets - About.com
The VALUE function is used to convert text to numbers. Doing so allows them to be used in calculations. An example of using Excel's VALUE function is included ...
EXCEL UPPER Function Tutorial - Spreadsheets - About.com
To convert this text all to upper case (capital letters) in Excel you can use the UPPER function. The syntax for the UPPER function is: = UPPER ( Text ). Text - the ...