SUM STRING UNTIL

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

"ancora" <ancora70@hotmail.it> schreef in bericht
news:1173866041.078892.245910@l77g2000hsb.googlegroups.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
>