Excel - COUNT Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc