Question description:
This user has given permission to use the problem statement for this
blog.
I would like to create a function that will automatically count the number of characters that I keyed on a cell.
Solved by I. W. in 24 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
29/05/2018 - 06:14
Hi
Excelchat Expert
29/05/2018 - 06:14
Welcome to Got It Pro.
User
29/05/2018 - 06:15
hello
Excelchat Expert
29/05/2018 - 06:15
I have referred the requirement.
Excelchat Expert
29/05/2018 - 06:15
Can you share the sample data? or i can show via an example
User
29/05/2018 - 06:15
i dont have data
User
29/05/2018 - 06:15
just create a sample
Excelchat Expert
29/05/2018 - 06:16
Please refer preview.
Excelchat Expert
29/05/2018 - 06:16
I have used len() function to calculate the number of characters in the cell A1.
Excelchat Expert
29/05/2018 - 06:17
Upon changing the text in A1, the formula counts the new characters
User
29/05/2018 - 06:17
no i want is, when i am currently typing that function will count too
Excelchat Expert
29/05/2018 - 06:18
That is not possible with formulas. You have to go for programming, in that case.
Excelchat Expert
29/05/2018 - 06:18
It updates the live data.
Excelchat Expert
29/05/2018 - 06:18
We are not supporting programming at the moment.
User
29/05/2018 - 06:21
but that was i needed
Excelchat Expert
29/05/2018 - 06:22
You have to chose another resource for this, as we are not supporting it. Sorry about that.
Excelchat Expert
29/05/2018 - 06:22
We are supporting Formulas, Graphs, Pivot tables.
Excelchat Expert
29/05/2018 - 06:28
Hi, there?
User
29/05/2018 - 06:32
sorry i was disconnected
User
29/05/2018 - 06:32
is there any other way to come up with that?
Excelchat Expert
29/05/2018 - 06:32
No. It is not possible without macro programming.
Excelchat Expert
29/05/2018 - 06:33
Unfortunately, we are not supporting.
Excelchat Expert
29/05/2018 - 06:33
Is there anything else, you want to assistance with?
User
29/05/2018 - 06:34
i'm getting mad on this
Excelchat Expert
29/05/2018 - 06:34
I think, i have explained the possibilities from our end. Thank you.
Excelchat Expert
29/05/2018 - 06:34
Please visit Got It Pro for new queries.
Excelchat Expert
29/05/2018 - 06:36
I think, you can end the session.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.