Excel Using Text Functions

Gary Schwartz's Blog

Excel is great for dealing with numbers but it also has functions for dealing with text. You can check in a bit of the text by extracting it using one of the functions like LEFT, RIGHT and MID.  You can also check on how many characters are in a string of text using the LEN functions (LEN for length), very useful for checking that the correct amount of text has been entered such as a credit card number.

View original post