LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I count the Characters in a cell Woozy Excel Discussion (Misc queries) 5 January 8th 09 08:26 AM
Count Characters in A Cell Daren Excel Discussion (Misc queries) 4 October 1st 08 02:34 PM
Count Characters in a cell tracktor Excel Discussion (Misc queries) 8 May 21st 08 03:02 AM
Count Characters with space in a cell NH Excel Discussion (Misc queries) 5 April 5th 07 05:07 AM
Count Number of Characters in a cell? AHJuncti Excel Discussion (Misc queries) 2 June 16th 05 07:39 PM


All times are GMT +1. The time now is 05:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"