LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Mirandolle
 
Posts: n/a
Default Help: I need a macro to add words every 3 lines

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Number to words literal JCP Excel Worksheet Functions 12 August 22nd 08 05:18 PM
soft-coding lines in a macro GJR3599 Excel Discussion (Misc queries) 1 March 30th 05 10:28 PM
Date macro Hiking Excel Discussion (Misc queries) 9 February 3rd 05 12:40 AM
macro to eliminate spaces between words CSAM Excel Discussion (Misc queries) 3 December 17th 04 11:39 AM
Macro and If Statement SATB Excel Discussion (Misc queries) 2 December 3rd 04 04:46 PM


All times are GMT +1. The time now is 02:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"