Microsoft® Excel® 2010 Formulas & Functions Inside Out

Chapter 8. Text and Data Functions

• ASC()

• BAHTTEXT()

• CHAR()

• CLEAN()

• CODE()

• CONCATENATE()

• DOLLAR()

• EXACT()

• FIND(), FINDB()

• FIXED()

• LEFT(), LEFTB()

• LEN(), LENB()

• LOWER()

• MID(), MIDB()

• PHONETIC()

• PROPER()

• REPLACE(), REPLACEB()

• REPT()

• RIGHT(), RIGHTB()

• SEARCH(), SEARCHB()

• SUBSTITUTE()

• T()

• TEXT()

• TRIM()

• UPPER()

• VALUE()

This chapter describes the text and data functions in Microsoft Excel (see Table 8-1). The text and data functions provide all the tools you need to convert text or numbers and to edit and evaluate strings. When working with imported lists, you might need these functions so that you can divide, combine, or evaluate text.

Table 8-1. Overview of the Text and Data Functions

Function	Description
ASC()	Converts double-byte characters into single-byte characters
BAHTTEXT() ...