Functions
LEFT/RIGHT Function – This returns a string from the left/right. You designate the number of characters to be returned
FIND Function – Find where a specific character is within a string. You can designate where you want to start in the string.
LEFT(text,[num_chars])
text = Text to analyze
num_chars = how many characters to pull from the text, starting on the left
*this works the same way for the RIGHT function
FIND(search_for,text_to_search,[starting_at])
search_for= what to search for
text_to_search= text to search
[starting_at]= where in the text to start the search
*Note – Within functions, square brackets are optional parameters.
Reference Types
So you know how before to lock a reference type you just pressed F4 till you saw all that Cash $$$? Well, you can add in the $s manually, and it actually gives you more control!
$ can be added before the column (ABC etc), before the row (1,2,3,4) or both!