Thread: counting the number of characters in a cell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default counting the number of characters in a cell
On Tue, 18 Dec 2007 13:11:06 -0800 (PST), wrote:

Is there a formula that will tell me how many character are in a
cell. For example


cell 1 Happy it will return 5
cell 2 Happy Birthday it will return 14

I need to include spaces in the count.

Thanks in advance for your help.


=LEN(cell_ref)


--ron
Reply With QuoteReply With Quote