Need a formula for becoming power spreadsheet user? I did.

Published 2011-10-31

Interested in boosting your knowledge of spreadsheet formulas? Paul Bradshaw has a fantastic compendium of handy formulas that actually allow you to achieve things.

Now many of you have probably learned your share of Excel forumlas, and I know a couple here and there. But what would you do to extract just one part of a cell's data?

Before this weekend, I didn't have a clue. Now I know I can just use =LEFT(, ), meaning if I want the first four characters from the cell A2, I'll just use =LEFT(A2, 4).

Handy right?