MarkeTrak Tips and Tricks

Excel has a number of built-in functions that can parse characters in a string. The function LEFT(cell, n) returns the left n characters from the specified cell. Thus, in our case, Left (C4,1) returns the left-most digit from cell C4. However, the various character-parsing functions (LEFT, RIGHT, MID) all return their results as text. Therefore, we need to transform that result back into a ... ................
................