Re: Help: I need a macro to add words every 3 lines
- From: Mirandolle <user@xxxxxxxxxxxxxx>
- Date: Fri, 05 Aug 2005 23:55:41 +0200
Hi Hitesh,
Thank you very much for your answer !! :-)
But, I am not sure to understand you... Point by point:
1- the English and French words are already entered... so I have a VERY looong list... to add a column with :
> \en > \fr > Blank
> \en > \fr > Blank
etc.... will be quite long (no ?)
2- I want the tags to be in front of the words. If I add \en and \fr tags to column B (on the right side of A column), I will get something like :
house \en maison \fr blank
Isn't it ? (\en and \fr should be at the start of each line)
Sorry for all these questions, but I am really bad at Excel... :-(
HITESH wrote:
Hi Mirandolle,
You dont need to use macro for your problem,assuming your data is in column "A" what you can do is just tag the adjacent colum "B" :
\en \fr Blank
and copy the tag till the last row of colum A
In colum "C" use the concencate formula and that will give you your data.
then just copy and past special values Colum C to colum A and yr data is ready.
To add one more row can be done by adding number is adjesent row and then sorting and then again updating the sequence number bt adding a text with a multiple of 3
for example 3A,6A,7A
"Mirandolle" wrote:
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
.
- Follow-Ups:
- Re: Help: I need a macro to add words every 3 lines
- From: Dave Peterson
- Re: Help: I need a macro to add words every 3 lines
- References:
- Help: I need a macro to add words every 3 lines
- From: Mirandolle
- RE: Help: I need a macro to add words every 3 lines
- From: HITESH
- Help: I need a macro to add words every 3 lines
- Prev by Date: Re: Month Formula
- Next by Date: Re: Month Formula
- Previous by thread: RE: Help: I need a macro to add words every 3 lines
- Next by thread: Re: Help: I need a macro to add words every 3 lines
- Index(es):
Relevant Pages
|
