**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.*