splitting one Column into many other columns

Hello,
I need a macro which place chosen parts from one column into another column.

For example I have following text in column E:

Column E
Flugschneise {f}
ringsum
(total) im Arsch [vulg.]
mutterseelenallein
Geld und Gut
Pensum {n}
totgelacht
*Schlotterkamm {m} [Ab- und Umbau des Kieferkamms]
Weißkopfseeadler {m}
Rabengeier {m}
Pfeilschwanzkrebs {m}
Indianer {m}
Indianerin {f}
Königsgeier {m}
Carolinataube {f}
Trauertaube {f}
Zwergsultanshuhn {n}
Amerikanischer Spitzmull {m}
Schwalbenweih {m}
Regenmenge {f}
Sachverstand {m}
Und damit basta! [ugs.]
(Und) damit hat sich der Fall.
(Und) damit ist die Sache erledigt.

*chosen content not always at the end of a cell!!

Now i need a macro which puts chosen content from Column E to Column F or Column G. For example I want that all “{f}s” should be deleted from column E and put into column E. Or I want all {n} to be deleted and placed into column F. Or I want all [vulg.] to be deleted from column E and put into column G. If column F or G already consist of text then the new text( {f} or {n} or [vulg.] ...) should be added to the existing text but separated through a separator like comma or semicolon …

It means that the macro is each time fed with information about what to delete from which column and where to put it. It would be cool if a simple msg box would ask for the needed information.

I hope that the problem is described understandable/precise by me. If not, please let me know.

Thanks in advance for every answer. And thanks a lot for commenting the solution/code if any as much as possible! :-)

Wali

Hi

Before I make a reply could you please post an example worksheet of what is in the destination cells and how you want it to be joined / added as it is difficult to know exactly what you want.

Regards

Jeff

Hi,
sorry it was a typing mistake. what i meant was that "{f}s" should be deleted from column E and put into column F. I attached an excel file and hope that it explains the problem better.

I have a word list containing many thousand of words. Now only one macro is needed which splits the wordlist into many. According to the example in Excel file imagine i told the macro to replace {f}s from column E to column F. The same macro was run again but this time it was asked to to replace {n}s from E to F. Third time it was asked to do that with {m}. Forth time [schule] from E to G....

It means the same macro is run many times till the data is put into those cells where the user want them to be. Every time before running the macro, the user should be asked " what to replace, from which column to which column?".

In the attached excle example i have used many sheets to demonstrate the steps. But in real the macro should do the work in only one sheet. More sheets are not needed

wali

Sorry, but I can only see the attachment with excel or picture formated files.

Hi,
thank for your quick answer.
unfortunately i cant attach excel file here. But i uploaded it for you and here is the external link where you can download the excel file:

splitting one column1.xls