String length

[jxbeeman]

what function do you use to return the length of a string in a cell???

EX.

SomeString = length is 10 characters long.

Thanks, Josh

 

[Kevin B]

Use the LEN function to return the length of a string value

=LEN(A1)

Returns the length of the string in cell A1