For example, the formula =LEN() gives back the number of characters in a cell. Pro tip 1: You can combine formulas to extract characters at all sorts of crazy positions. =MID(B1,4,2) to extract the 2 characters following the 4th character in B1. =RIGHT(B1,8) to extract the last 8 characters of the cell B1.
=LEFT(B1,2) to extract the first 2 characters of the cell B1. Sometimes you don’t have clear separator characters, but just want to extract the first or last characters of a cell.
