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]]

Re: SUM STRING UNTIL

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@hotma il.itschreef in bericht
news:1173866041 .078892.245910@ l77g2000hsb.goo glegroups.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
>