View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ragdyer
 
Posts: n/a
Default COUNT THE NUMBER OF LETTERS INCLUDING SPACES IN A CELL?

Try this:


=LEN(A1)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"zurafz6" wrote in message
...
Im currently creating codes for our inventory list. The system provider
mentioned that my codes can only have 30 characters including spaces and
symbols. Now I have my list but it will be easy for me if there is a

function
which will help me count the number of characters in a cell. From there I
will be able to identify those codes which exceed 30 characters and modify

my
list.

Thanks. It will be a great help.