Sheets – (LEFT, FIND,SEARCH functions, Reference Types) Extracting Root Domain from URLs

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!