1. Tech

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 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
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
Convert Case for Text Data with the Excel PROPER Function
The PROPER function is used to convert text data to proper case letters ( combination ... Spreadsheets Excel Functions ... Excel Functions · Excel Text Functions ...
http://spreadsheets.about.com/od/excelfunctions/qt/8124_proper.htm
Convert Text to Numbers in Excel - Spreadsheets - About.com
How to convert text data to numbers in Excel using the VALUE function. ... When this situation occurs, certain functions, such as SUM or AVERAGE, ignore the ...
http://spreadsheets.about.com/od/Text-Functions/ss/2011-05-26-excel-convert-text-to-numbers.htm
EXCEL UPPER Function Tutorial - Spreadsheets - About.com
The UPPER function is used to convert text to all upper case or capital letters. ... One of Excel's TEXT functions ... Example: Using Excel's UPPER Function.
http://spreadsheets.about.com/od/excelfunctions/qt/81206_upper.htm
Truncate Text Data in Excel - Spreadsheets - About.com
Jan 31, 2011 ... Excel has several functions that can be used to truncate or remove such unwanted characters. Which function you use depends upon where ...
http://spreadsheets.about.com/od/Text-Functions/ss/2011-01-31-excel-2010-truncate-text-strings-left-function.htm
Excel TRIM Function Alternative Formula - Spreadsheets - About.com
The TRIM function cannot always remove extra spaces from text data. An alternative formula ... Tech · Spreadsheets . . . Excel Functions · Excel Text Functions ...
http://spreadsheets.about.com/od/excelfunctions/qt/080404_trim.htm
Remove Extra Spaces in Excel - Spreadsheets - About.com
Excel Functions · Excel Text Functions ... When text data is imported or copied into an Excel spreadsheet extra spaces can sometimes be included along with the ...
http://spreadsheets.about.com/od/Text-Functions/ss/2011-05-28-excel-2010-trim-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
1  |  2  |  3  |  4  |  5  |  6  |  7  |  8  |  9  |  10      Next

©2015 About.com. All rights reserved.