Excel Spreadsheets Functions: Text

    

613-749-4695
[email protected]

Home Page

Tips and Ideas on Excel
Table of Contents on Excel

Tips and Ideas on Macros
Table of Contents on VBA

Quick Links

 

This page is offered to you as reference
You will probably use only 42% of these Excel spreadsheet functions

See Excel Text formulas in chapter 22

 

Excel Lesson 24J of 24: Excel Spreadsheets Text Functions List (24)

Here is the list of the functions of the text category. Of the 24 functions of the text category 10 are interesting and useful. Follow the links below to discover formulas using them.

When working with text the most important tool is not a function but the ampersand &

Importance Functions What it Does
Interesting CONCATENATE Joins several text items into one text item
Interesting FIND Finds one text value within another (case-sensitive)
Interesting LEFT Returns the leftmost characters from a text value
Interesting LEN Returns the number of characters in a text string
Interesting MID Returns a specific number of characters from a text string starting at the position you specify
Interesting REPT Repeats text a given number of times
Interesting RIGHT Returns the rightmost characters from a text value
Interesting TEXT Formats a number and converts it to text
Interesting TRIM Removes spaces from text
Interesting VALUE Converts a text argument to a number

Rarely Used

BAHTTEXT Converts a number to text, using the (baht) currency format

Rarely Used

CHAR Returns the character specified by the code number

Rarely Used

CLEAN Removes all nonprintable characters from text

Rarely Used

CODE Returns a numeric code for the first character in a text string

Rarely Used

DOLLAR Converts a number to text, using the $ (dollar) currency format

Rarely Used

EXACT Checks to see if two text values are identical

Rarely Used

FIXED Formats a number as text with a fixed number of decimals

Rarely Used

LOWER Converts text to lowercase

Rarely Used

PROPER Capitalizes the first letter in each word of a text value

Rarely Used

REPLACE Replaces characters within text

Rarely Used

SEARCH Finds one text value within another (not case-sensitive)

Rarely Used

SUBSTITUTE Substitutes new text for old text in a text string

Rarely Used

T Converts its arguments to text

Rarely Used

UPPER  Converts text to uppercase

Back to All Functions

 

Back to Introduction on Excel

Excel Table of Contents
or use the quick links below

 

Discover Even More in 50 Excel spreadsheets

 

    

613-749-4695
[email protected]

Home Page

Tips and Ideas on Excel
Table of Contents on Excel

Tips and Ideas on Macros
Table of Contents on VBA

Quick Links

Excel Spreadsheets Functions: Text