use Len function in the cell

S

Shinya Koizumi

How can i use the function Len in the cell from visual basic?
I want to get the number of characters in a particular cell without
caring about multibyte characters or single byte character.
i tried to look for worksheetfunctions, but couldn't find it.


SK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WORD VBA Search and switch to advanced ... 1
Excel does not accept text format! 0
Count Number of Unique Cells That Don't Have Certain Characters 0
Word macro that can call cells out of Excel for a find and replace 0
Len & Trim Function 6
Find text in cell and copy from 4 characters in front of the found text. 2
Cell format crosstalk 0
find and replace numeric strings in larger text strings 8

Top