View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] kousanee@gmail.com is offline
external usenet poster
 
Posts: 1
Default Need Help in counting + sign in a cell

I am entering the following in a cell: =5+8+60+1

Now I would like to do two things:
1. I would like to count number of numerical terms in this entry
(e.g. 4 in the above example). Is there any way of counting + sign in
cell and showing the result in a different cell?

2. I would like to see the content of the above cell as is (i.e.,
=5+8+60+1) in another cell of a different worksheet of a workbook.

-Peter