View source for Trimming Characters from Text String

=== Basic String Manipulation ===
Left: Use this to get the x characters from the left side.

<code>LEFT(string, extract length)</code>


Right: Use this to get the x characters from the right side.

<code>RIGHT(string, extract length)</code>


Mid: Use this to get the x characters in the middle

<code>MID(string, starting_at, extract_length)</code>


Len: Use this to see how many characters are in a specific cell

<code>LEN(text)</code>

=== Advanced String Manipulation ===
Combining Mid and Len to get data that may not always be the same length due to unique data

<code>=MID(string,LEN(“Repeatable Phrase in String“),extract length)</code>


[[Category:Google Sheets]]