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/
EXCEL LEFT Function - Excel Text Functions - Spreadsheets
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 ... To easily convert this to proper case (which uses partial capitalization) Excel has the  ...
http://spreadsheets.about.com/od/excelfunctions/qt/8124_proper.htm
Extract a Substring Using the MID Function in Excel - About.com
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 ...
http://spreadsheets.prodtx.about.com/od/Text-Functions/ss/2011-01-31-excel-2010-truncate-text-strings-mid-function.htm
Convert Text to Numbers in Excel - 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.prodtx.about.com/od/Text-Functions/ss/2011-05-26-excel-convert-text-to-numbers.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 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
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
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
Excel RIGHT Function to Truncate Text - Spreadsheets - About.com
Sep 22, 2007 ... The RIGHT function is used to truncate text strings in Excel by removing unwanted characters from the right side of a data entry. This tutorial ...
http://spreadsheets.about.com/od/excelfunctions/qt/20070922_right.htm
1  |  2  |  3  |  4  |  5  |  6  |  7  |  8  |  9  |  10      Next

©2014 About.com. All rights reserved.