Whether you need to manipulate text data to standardize or clean it or extract specific characters from a cell, you can use the LEFT, RIGHT, and MID functions to do just that. These functions extract specific characters from anywhere in a cell—whether text or numbers.
from MakeUseOf https://ift.tt/nlXwZI3
via IFTTT