Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Count letters, combine text, and compare text


Function name Used to
LEN count the number of characters in a cell
CONCATENATE combine information from two cells into one cell
EXACT compare two cells

Function names summarize long formulas.

COURSE TEXT

Instead of counting the number of letters in a cell, retyping to combine information from two cells into one, or proofreading to compare cell contents, let Excel do the work for you by using formulas. In the practice session, you'll have a chance to use the formulas and functions you've learned about.

To continue reading this lesson on your own, click the Next button.

  Go to previous page    Next Go to next page
advertisement