View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ancora ancora is offline
external usenet poster
 
Posts: 4
Default STRING SUM 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