Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|