SUM STRING UNTIL

  • Thread starter Thread starter ancora
  • Start date Start date
A

ancora

in A column i have many records as string like

(A)
one
two
three
four five
ten
ten nine
nine
.....
.....
.....
etc


with vba i would find all the SUM string that have at least "x"
characters including spaces between the strings, for example if i
would like to find the sum string with "8" characters at least, I'll
get in column B those SUM strings like follow


(B)
one nine
two nine
ten nine


where all the found strings have 8 characters


thanks a lot for your precious support
 
Ancora,

We won't give help to typical scolar question.

However if you want to solve a project, than first start to define it right.

In my opinion has four five more than 8 characters while I see nowhere one
and two nine

To give you a hint, you can probably do your job by using the string method
..length

Cor
 
Back
Top