View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Still Learning Still Learning is offline
external usenet poster
 
Posts: 31
Default 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.