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 support

.

Relevant Pages

  • Re: Reading Russian text in Word2003 VBA code
    ... Likely, your string contains the correct cyrillic string, but the control ... The VBA editor, immediate window or a MsgBox will display question marks ... for characters that aren't in the code page they are set up for. ... Whether the database can deal with Unicode, or the mechanism that you use ...
    (microsoft.public.word.vba.userforms)
  • Re: Importing a large amount of data as 1 line string
    ... the contents of a file into a VBA string. ... linebreak every 80 characters and leave the original file as a backup. ... The data is mixed text and numeric so I need the data type as ...
    (microsoft.public.access.externaldata)
  • Re: Byte Array to String
    ... retrieved text will mismatch the original characters. ... I think VBA may use the default system locale to ... encoding the characters. ... Dim strFileData as String ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Prothon should not borrow Python strings!
    ... """It does not make sense to have a string without knowing what encoding ... same cul de sac as Python. ... Prothon_String_As_ASCII // raises error if there are high characters ... Python's split between byte strings and Unicode strings is ...
    (comp.lang.python)
  • Re: Letter to US Sen. Byron Dorgan re unpaid overtime
    ... put them in stupid places. ... Programming is difficult (as you must surely appreciate, ... > strings will be in the range 1...1000 characters. ... impose an artificially small limit on string length." ...
    (comp.programming)