Excel LEN Formula

-

 LEN Formula 


This formula is used to calculate the number of character in a cell or Text.




Example


=LEN(A1)





Result - 6




Cell A1 value is Shivam which has 6 Character length.


Comments

Post a Comment

Popular posts from this blog

IF Formula in Excel

-
Image
 IF Formula   IF function is Logical function which is used to perform a logical test. Example =IF(A1>33,”P”,”F”)  Result - P The value of Cell A1 is 50 which is greater than 33. The logical test is, IF the value is greater than 33 then result would be P else the result would be F. So the result is P.
Read more