Counting number of characters in a cell
Thank you very much - was of great help!
"Pete_UK" skrev:
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
On Oct 14, 12:38 pm, Still learning
wrote:
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.
|