How to count the number of characters in a cell 1

dutchmen · Jul 17, 2002

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 · Jul 17, 2002

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.

[atom]

Richard Nornhold, PE
nornrich@redrose.net

dutchmen · Jul 17, 2002

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

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

How to count the number of characters in a cell 1

dutchmen

Materials

Recommended for you

nornrich

Mechanical

dutchmen

Materials

Similar threads

Part and Inventory Search

Sponsor