Hi guys,
In order to create a bi-lingual glossary, I'm in need of a function which must:
1. cut from column 1 and paste in column 2, the word(s) contained between the sign "=" exclusively and the sign "(" also exclusively;
2. cut also from column 1 and paste in column 3, the word(s) contained between the sign "(" inclusively, and the sign ")" also inclusively.
This operation should be repeated for approximately 1500 lines.
Should it simplify, you may generate one macro which does step 1 and another which does step 2, separately.
Appreciate very much your help.
In order to create a bi-lingual glossary, I'm in need of a function which must:
1. cut from column 1 and paste in column 2, the word(s) contained between the sign "=" exclusively and the sign "(" also exclusively;
2. cut also from column 1 and paste in column 3, the word(s) contained between the sign "(" inclusively, and the sign ")" also inclusively.
This operation should be repeated for approximately 1500 lines.
Should it simplify, you may generate one macro which does step 1 and another which does step 2, separately.
Appreciate very much your help.
