| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I control the length of characters a code will return?
After generating random characters using this command given by a member of
this discussion group: =MID(A1,5+INT(RAND()*LEN(A1)),5), how do I correct the following outputs? (1) How can I make sure that the characters generated are not repeated in any of the cells? (2) Some cells returns null characters while some others return characters whose length is less than the specified length in LEN (5 in this case). How can I control the length of characters the code will return? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Syntax to return the value of a control by reference | Excel Discussion (Misc queries) | |||
| Limiting physical length of text in a text box control | Excel Discussion (Misc queries) | |||
| can you entre a bar code into a excel cell? | Excel Worksheet Functions | |||
| Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
| Command Button VBA code | Excel Discussion (Misc queries) | |||
Linear Mode
