View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
K[_2_] K[_2_] is offline
external usenet poster
 
Posts: 557
Default Count Text Characters in cell

Hi all, I know that if you put formula "=LEN(A1)" in cell B1, it will
show the result of numbers of text characters been input in cell A1.
My question is that the result in cell B1 will appear only when you'll
put text in cell A1 and press Enter or Tab on your keyboard, but is it
possible or is there any simple way to see the result in cell B1 while
you are typing. Like if you putting text in cell A1 and the same time
you can see the numbers in cell B1 that how many text character you
have put in cell A1. If any friend have any suggestion or can help it
will be very helpful.