Question: Which function returns the number of characters in a text string in cell A1?

  1. `=RIGHT(A1)-LEFT(A1)+1`
  2. `=LEN(A1)`
  3. `=EXACT(A1)`
  4. `=CHARS(A1)`

Answer: The correct answer of the above question is Option B:`=LEN(A1)`