Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Text

 
ASC*The text string converted to single byte characters.
BAHTTEXTThe number converted to Thai text and adds the word "Baht".
CHARThe character with the corresponding ANSI number.
CLEANThe text string with all the non-printable characters removed.
CODEThe ANSI number for the first character in a text string.
CONCATENATEThe text string that is a concatenation of several strings.
DOLLARThe text string of a number with the dollar formatting $0,000.00.
EXACTThe boolean value based on whether two strings match exactly.
FINDThe position of a substring within a larger text string.
FIXEDThe text string of a number rounded to a fixed number of decimal places.
JISThe text string with all the characters converted to double byte characters.
LEFTThe first or left most character (or characters) in a text string.
LENThe number of characters in a text string.
LOWERThe text string with all the characters converted to lower case.
MIDThe text string which is a substring of a given string.
PHONETICThe phonetic characters from a text string.
PROPERThe text string with the first letter of every word as a capital letter.
REPLACEThe text string with a number of characters replaced.
REPTThe text string with a smaller text string repeated a number of times.
RIGHTThe last or right most character (or characters) in a text string.
SEARCHThe position of a substring within a larger text string.
SUBSTITUTEThe text string with a substring substituted for another substring.
TThe text string of the value given.
TEXTThe text string of a number in a particular format.
TRIMThe text string with all spaces removed from the beginning and end.
UPPERThe text string with all the characters converted to upper case.
VALUEThe number that a text string represents.
 
 Note: * These are Analysis ToolPak functions

 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top