How to
 

Does anyone know if i can take a set of numbers, letters, and change the
sequence of them up to 120000? for instance fzfll1 or 5 mz8bnd

How to
 

and change the sequence of them up to 120000?

Do you mean change the sequence up to 120000 times without producing a
duplicate?

RBS

"dt" wrote in message
. ..
Does anyone know if i can take a set of numbers, letters, and change the
sequence of them up to 120000? for instance fzfll1 or 5 mz8bnd

How to
 

I do it all the time. I usually use Left, right, and mid statements to get
the old letters and then combine them using the +.

reverse the order of "ABC"

mystring = "ABC"
reverse string = mid(mystring,3,1) + mid(mystring,2,1) + left(mystring,1)

to extract everything before a ;

mystring = "123;456"

firstring = left(mystring,instr(mystring,";") - 1)
secondstringg = mid(mystring,instr(mystring,";") + 1)


Other string functions

CLEAN Removes all nonprintable characters from text
FIND Finds one text value within another (case-sensitive)
LEFT Returns the leftmost characters from a text value
LEN Returns the number of characters in a text string
MID Returns a specific number of characters from a text string starting at
the position you specify
REPLACE Replaces characters within text
REPT Repeats text a given number of times
RIGHT Returns the rightmost characters from a text value
SUBSTITUTE Substitutes new text for old text in a text string
T Converts its arguments to text
TEXT Formats a number and converts it to text
TRIM Removes spaces from text


"dt" wrote:

Does anyone know if i can take a set of numbers, letters, and change the
sequence of them up to 120000? for instance fzfll1 or 5 mz8bnd

How to
 

A bit more explanation required.
I don't understand "take a set of numbers, letters, and change the sequence
of them up to 120000"

NickHK

"dt" wrote in message
. ..
Does anyone know if i can take a set of numbers, letters, and change the
sequence of them up to 120000? for instance fzfll1 or 5 mz8bnd