Excel Text Functions

Text functions in Excel really deal with a string of characters and can be used to check the length of some text telling you how many characters there are, useful for checking entries like credit card numbers. You can also find sections of text and even use it to do things like split a name into two separate cells (click here for a link to that example).

You can also convert text to uppercase, lowercase and proper.

The functions used here are LEFT(), RIGHT(), MID(), FIND(), LEN(), UPPER(), LOWER() and PROPER()