Revamped formula

[rligh]

The formula I was provided with on this forum worked for a little, but I've quickly figured out that there might be a more efficient way to do what I'm attempting to do. Is this possible?

I have a list of prefixes I want to mash with anywhere from two to maybe seven letter suffixes. If there's a way to auto generate those suffixes that would be ideal.

ie:

suffix pulled from my list is PEN, code generates a four letter suffix to go with it: ENOX (penenox)
suffix pulled from my list is XER, code generates a two letter suffix to go with it: ZA (xerza)

If it at all helps, I'm trying to generate a list of words that can be used as names.

 

[rligh]

Would I need to switch over to excel for this?

 

[Joe4]

Would I need to switch over to excel for this?

This isn't an Excel question???

This is an Excel forum. If you therefore have a question that is NOT an Excel question, you need to explicitly tell us what application you are inquiring about, as Fluff mentioned here in your last thread: Replace last character with its sequential letter for Numbers (Apple)

 

[rligh]

I was under the impression its in my profile that I was using numbers. My most sincere apologies.

 

[Joe4]

This is what people see, regarding what you are using:

So, if you are asking about anything other than Excel (or different from that version of Excel), you need to mention it in the title/question, as Fluff directed:

In future when using something other than Excel, please make that clear, preferably in your title & you need to post such questions in the General Discussion & Other Applications section of the board. I have moved it for you this time.

 

[rligh]

I withdraw my question then, I apologize for whatever misteps I’ve made. My best to you all.

 

[Joe4]

No need to withdraw question. You are free to ask it.
Just trying to make your realize why you need to do this (instead of telling you have to without any explanation).
If you do not, you will most likely get an Excel answer, by default (since this is an Excel forum), which will only lead to frustration to both you and the person trying to help you.
We are trying to help you avoid that aggravation, and increase the likelihood of getting the help you want.

If you would like to re-post the question, clearly indicating what non-Excel application it is for, I will gladly remove this thread from the Board for you.
That way it will appear as a new, unanswered question (with no replies).
Just let me know if you would like to do that.