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