Is there a combination of functions that could be used to reorder a series of letters residing in cell A1 to list all the possible arrangements of those letters? For example: If A1 contains the text: "ABCD"; I would want to see all the possible arrangements of those four letters listed in column B starting at B1 with "ACDB" or "DCBA" (or any other), then in B2: "ADCB", etc.
Any ideas?
Any ideas?