I want to generate all possible combinations of names and abbreviate the first name only, leaving the last name unchange.
for example if i input a name in cell A1 "Jean Sam Paul ZAVIER", ZAVIER being the last name; i want all possible combination, that is
A2:J ZAVIER
A3:S ZAVIER
A4:P ZAVIER
A5:J P ZAVIER
A6:J S ZAVIER
A7:S P ZAVIER
A8:J Sam Paul ZAVIER
A9:Jean S Paul ZAVIER
A10:Jean Sean P ZAVIER
A11:Jean P ZAVIER
A12:J Paul ZAVIER
A13: J S P ZAVIER....etc
Is there a way for excel to generate a list of all possible combination..Thank you
Bookmarks