View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default Formula/Function for Counting Characters in a cell

Hi
Try this function =Len(cell #)
HTH
John
"CyndiR" wrote in message
...
I'm trying to find a formula/function that count all characters in a cell.

Our employee's street address may exceed the maximum 25 characters allowed
and I need to know how many characters are in each street address cell so we
can edit it, if needed. Characters include numbers, text, spaces and
different characters such as # sign, commas, etc.
--
Thanks,
Cynthia