How to count the number of characters in a cell 1

[dutchmen]

As part of a visual basic program I need to count the number of characters used in a cell. For example, if cell A1 in a workbook contains the text: How are you today?, the function or macro should give: function(A1) equals 15.
Thank yo in advance for your help.

 

[nornrich]

You could use the Len() function, but the value that is returned for "How are you today?" will be 18. This is because spaces are counted as characters.

Richard Nornhold, PE
nornrich@redrose.net

 

[dutchmen]

Problem solved. Thank you for this, for me, very useful tip.