ExcelBanter - String length

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - String length (https://www.excelbanter.com/excel-discussion-misc-queries/172496-string-length.html)

jxbeeman

String length

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

String length

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

=LEN(A1)

Returns the length of the string in cell A1
--
Kevin Backmann

"jxbeeman" wrote:

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

EX.

SomeString = length is 10 characters long.

Thanks, Josh

All times are GMT +1. The time now is 02:56 PM.