Question description:
This user has given permission to use the problem statement for this
blog.
I want a function that will automatically count the number of characters on a certain cell?
Solved by A. U. in 23 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
25/05/2018 - 06:59
Hello there
Excelchat Expert
25/05/2018 - 07:00
can you see the shared view?
Excelchat Expert
25/05/2018 - 07:14
hello?
Excelchat Expert
25/05/2018 - 07:17
=len(SUBSTITUTE(B1," ",""))
Excelchat Expert
25/05/2018 - 07:18
This is the formula to use
Excelchat Expert
25/05/2018 - 07:18
B1 is the cell in consieration
Excelchat Expert
25/05/2018 - 07:18
*consideration
Excelchat Expert
25/05/2018 - 07:18
That is all
Excelchat Expert
25/05/2018 - 07:20
here is a sample demo: https://docs.google.com/spreadsheets/d/12NzE9HN7nur1h45up7ik5gl4Mw5yYJvNJG7edJFG29k/edit?usp=sharing
Excelchat Expert
25/05/2018 - 07:21
attached
[Uploaded an Excel file]
Excelchat Expert
25/05/2018 - 07:21
thanks for being here
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.