Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Technically, there is nothing in the cell until it is committed with ENTER,
TAB, etc. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "K" wrote in message ... 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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
is it possible or is there any simple way to see
the result in cell B1 while you are typing. No, that is not possible. When you're typing something in a cell Excel is in edit mode and nothing can happen until Excel is out of edit mode. What that means is until you're done typing and hit the enter key (or click the enter icon on the formula bar, or tab, or the directional arrow keys) Excel can't calculate how many characters you've typed. -- Biff Microsoft Excel MVP "K" wrote in message ... 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. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
Although you can't do this with a spreadsheet cell you can do this on a userform which could then enter the data in the cell. With a form containing a textbox and a label this would be the code Private Sub TextBox1_Change() Me.Label1 = Len(Me.TextBox1) End Sub -- If this helps, please click the Yes button Cheers, Shane Devenshire "K" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I count the Characters in a cell | Excel Discussion (Misc queries) | |||
Count Characters in A Cell | Excel Discussion (Misc queries) | |||
Count Characters in a cell | Excel Discussion (Misc queries) | |||
Count Characters with space in a cell | Excel Discussion (Misc queries) | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) |