Example: When you've got the title "John Smith" in mobile A1 and you would like to calculate the length of the complete name, You should utilize the components =LEN(A1) to acquire the result of 10, which includes the space between the primary and last title.Since the flash fill element is sort of fantastic with recognizing designs, it’s a terrifi