We need to generate all possible name combinations using, which for now
includes 10 first names, 26 middle initials (a-z), and 10 last
names...ie 2,600 total names- with no dupes..
If we start with the 10 first names in column/field 1 and the 26
initials in field 2 and the 10 last names in field 3, is there a single
formula or series of steps to end up with the 2600 names in a single
field, with 2600 records?
A super bonus would be a space between the first name and middle
intiial, and then a period after middle initial (which, actually, I
assume we could build into/onto the 26 initial items) and then another
space and then last name...ex. "Happy B. Smart" (these are character
names for childrens project). If we set up the intiial 26 letters in
field 2 and the 10 last names in field 3 with a space prior to each of
them, will the formula simply leave the space in place- or is it more
complicated?
Thanks.
Bookmarks