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

String centering 2
Max Length in a row 1
Insert prefix and suffix to existing string 1
Sumproduct which counts Text in cell 4
Indent based on character length 4
Cut the last 20 characters out of a text string 4
How many pieces of trim molding to order? 0
Adding recognised Zeros 5

Top