Hi,
I need a macro that will generate (in column A), a non-duplicate list of alphanumeric characters of length 3. In other words, a list that starts with "aaa" in cell A1, and ends with "999" in cell A238,328. Each character can be numeric (0 - 9), lowercase alpha, or uppercase alpha.
I want to do this in an orderly fashion, not by generating random strings.
Can someone help me?
Thanks,
Mark
With this syntax :
Please Login or Register to view this content.
[Here is the code. Be aware this generates a quarter of a million rows.]<--I see you already knew this
You must format column A as Text first to preserve the strings that are all numeric and start with 0.
Please Login or Register to view this content.
Thanks Logit and Jeff! I knew that there had to be a relatively straightforward way of doing this.
Thanks again!
Mark
Last edited by MagPower; 11-26-2016 at 11:47 AM.
Your welcome
Thanks for the add rep.
Last edited by Logit; 11-26-2016 at 12:26 PM.
You're welcome and thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks