SUM STRING UNTIL

[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

[Cor Ligthert [MVP]]

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

"ancora" <an******@hotmail.itschreef in bericht
news:11**********************@l77g2000hsb.googlegr oups.com...

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