=len(A2)
The excel formula above will tell you the total length of characters in cell A2. The formula also considers spaces as part of it's count of the number characters. So, if you had the word count with a single space after it like this: "Count ". It will sum the number of characters in the word count and add the single space as well, which would come to 6 as opposed to 5. Also if you had the word "Mark" with no spaces in it. it would give you the sum of 4 as the length of characters being that there are only 4 characters in the word Mark.
The excel formula above will tell you the total length of characters in cell A2. The formula also considers spaces as part of it's count of the number characters. So, if you had the word count with a single space after it like this: "Count ". It will sum the number of characters in the word count and add the single space as well, which would come to 6 as opposed to 5. Also if you had the word "Mark" with no spaces in it. it would give you the sum of 4 as the length of characters being that there are only 4 characters in the word Mark.
0 comments:
Post a Comment