String length

J

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
 
K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cut the last 20 characters out of a text string 4
Indent based on character length 4
how to avoide duplicate entries in to cell 2
one cell to many 2
Excel Subtract text after the third space and before the fourth (from between spaces) 3
Sumproduct which counts Text in cell 4
Max Length in a row 1
Last piece of text in a string (multiple lengths) 3

Top