final version v1.0:
added trim and case normalization (remove leading and trailing spaces and convert everything to lowercase). case normalization can be switched on or off by clicking a checkbox next to the "create combinations" button
no more need to fill emty columns with spaces. Empty columns and cells will be ignored.
Attention!: this version is only compatible with MS Excel. Libreoffice and OpenOffice will spit out errors because of a different VBA implementation. Version 0.2 should work with any *.Office.
Version v0.2:
First: English is not my native tongue so it might sound a bit rough, but i'll try my best.
Tired of typing hundreds of combinations to a text file?
Search no more. The Wildcard Generator is here. It is an Excel file with Makros to help you create every possible combination of terms you enter.
How to use:
There are 6 columns for you to fill with your terms. For example:
Column1:
Cell1: long
Cell2: short
Cell3: asymmetrical
Column2:
Cell1: blonde
Cell2: black
Cell3: ginger
Column3:
Cell1: updo
Cell2: undercut
Cell3: braids
and so on. When you click the button, it will create every combination of these terms: long blonde updo, long blonde undercut, long blonde braids, long black updo, long black undercut, long black braids, ... You already understand where this is going. This example will create 27 combinations, 3x3x3 = 27
You can use up to 6 columns. If you need more, try to combine columns with few terms into one. You can as well edit the code if you have the skills or just ask chatGPT.
If you don't need a column type a space into the first cell. An empty column will print an error. I'll try to fix this someday.
I hope this will be useful to you.