1. Technology

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.
http://spreadsheets.about.com/od/exceltextfunctions/
Clean Up Imported Data in Excel with the MID Function
Note: Even though the MID function is one of Excel's Text functions, the function can also be used to extract a subset of numeric data from a longer number using  ...
http://spreadsheets.about.com/od/Text-Functions/ss/2011-01-31-excel-2010-truncate-text-strings-mid-function.htm
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 ...
http://spreadsheets.about.com/od/excelfunctions/qt/20070921_left.htm
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.
http://spreadsheets.about.com/od/excelfunctions/qt/8124_proper.htm
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.
http://spreadsheets.about.com/od/excelformulas/u/formulas_functions_user_path.htm
Excel LOWER Function - One of Excel's TEXT functions
The LOWER function is used to convert text to all lower case letters. A step by step example is included with this tutorial.
http://spreadsheets.about.com/od/excelfunctions/qt/81206_lower.htm
EXCEL UPPER Function Tutorial - Spreadsheets - About.com
The UPPER function is used to convert text to all upper case or capital letters. An example of using this function is included in the tutorial.
http://spreadsheets.about.com/od/excelfunctions/qt/81206_upper.htm
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  ...
http://spreadsheets.about.com/od/Text-Functions/ss/2011-05-26-excel-convert-text-to-numbers.htm
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  ...
http://spreadsheets.about.com/od/excelfunctions/qt/81206_value.htm
Excel REPLACE Function - Spreadsheets - About.com
Excel's REPLACE function can be used to replace these unwanted characters with good data ... Choose Text from the ribbon to open the function drop down list .
http://spreadsheets.about.com/od/excelfunctions/qt/080817_replace.htm
1  |  2  |  3  |  4  |  5  |  6  |  7  |  8  |  9  |  10      Next

©2014 About.com. All rights reserved.