Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello,
I understand nothing to macro but I am sure that a macro can resolve my problem. I have the following columns, for example (it is for a dictionary database): House Maison [empty line] Car Voiture [empty line] Dog Chien [empty line] etc..... The first word is always in English and the second is always french. There is only 1 column but many lines. I would like to add "\en" in front of each English word, and "\fr" in front of each French word (in the same cell - I do not want to add a colum)... as a result I should get : \en House \fr Maison \en Car \fr Voiture \en Dog \fr Chien etc..... Could someone give me a macro for that ? hum.. if I do not abuse :-/ ... which macro would do this (if I want to add another line:) \en House \nnoun \fr Maison \en Car \noun \fr Voiture \en Dog \noun \fr Chien etc... A big THANKS! for any help! :-) Miradonlle |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Number to words literal | Excel Worksheet Functions | |||
soft-coding lines in a macro | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
macro to eliminate spaces between words | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) |