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.
|