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
Truncate Text Data in Excel with the LEFT Function - Spreadsheets
Jan 31, 2011 ... Excel's LEFT function can be used to remove unwanted characters from imported data or truncate text data. This tutorial includes a step by step ...
http://spreadsheets.about.com/od/Text-Functions/ss/2011-01-31-excel-2010-truncate-text-strings-left-function.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
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 ...
http://spreadsheets.about.com/od/tipsandfaqs/qt/if_enter_text.htm
1  |  2  |  3  |  4  |  5  |  6  |  7  |  8  |  9  |  10      Next

©2014 About.com. All rights reserved.