Counting number of characters in a cell

[Still learning]

I have a column with many rows of text (brief product descriptions). I need
to identify which cells have a content of more than 35 characters, since I
will need to alter these cells to make them fit a database. Does anyone know
how to do so? Thank you.

 

[Mike H]

Hi,

to test the length use

=Len(a1)

to return the leftmost 35 characters you don't need to test simply use

=Left(a1,35)

If the cell is <35 you get all the characters


Mike

 

[Pete_UK]

Use this function:

=LEN(A1)

to tell you how many characters (length) are in A1.

You can also use:

=LEFT(A1,35)

to give you the first 35 characters from A1.

Hope this helps.

Pete

 

[Still learning]

Thank you very much - was of great help!

"Pete_UK" skrev:

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete