• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part VIII: Appendixes > Text Functions

Text Functions

When working with text in worksheets, you often need to manipulate that text, or convert it to something else, or extract data from within the text strings. The text functions within Excel are like a Swiss Army Knife for manipulating text information. Table B.9 shows you these versatile functions.

Table B.9. Text Functions in Excel
Function SyntaxReturns
=CHAR(number)Character based on a code number from within the selected character set
=CLEAN(text)Text with all unprintable characters removed
=CODE(text)Code number of the first character of a string
=CONCATENATE(text1,text2,)Joined text strings
=DOLLAR(number,decimals)Text representation of a number using a currency format
=EXACT(text1,text2)Logical TRUE or FALSE based on whether two pieces of text match (case-sensitive)
=FIND(find_text,within_text,start_num)Index number locating a text string from within a larger string based on a criteria
=FIXED(number,decimals,no_commas)Text form of a number, rounded
=LEFT(text,num_chars)Left-most portion of a text string at a given length
=LEN(text)Number of characters in a string
=LOWER(text)Lowercase-only string based on another string
=MID(text,start_num,num_chars)Middle of a text string based on a starting position and length that you specify
=PROPER(text)Text string converted to title case (first letter of each word capitalized)
=REPLACE(old_text,start_num,num_chars,new_text)Replaces part of a text string with another text string
=REPT(text,number_times)Repeated set of text strings, a specified number of times
=RIGHT(text,num_chars)Right-most portion of a text string at a given length
=SEARCH(find_text,within_text,start_num)Index number where search text is found within a text string
=SUBSTITUTE(text,old_text,new_text,instance_num)Text with a portion of a text string replaced by another text string
=T(value)Text of a specified value
=TEXT(value,format_text)Text based on a value, in a given number format
=TRIM(text)Text with extra spaces removed (except single spaces between words)
=UPPER(text)Uppercase-only string based on another string
=VALUE(text)Value of a numerical text string



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint