Inserting extra info into a cell

[Neil Greenough]

I currently have three columns in a spreadsheet. This spreadsheet is used as
a bilingual glossary of terms. The first column simply contains the
following:

**

Now the second column contains my Spanish words and the third column my
English words. So, it looks something like this:-

** Hola Hello

Now, I wish to import this data into some new software I have however, it
requires me to put the word <Spanish> before every words in the second
column and <English> before every word in the third column. So, in essence,
it will be

** <Spanish>Hola <English>Hello

I have over 3000 rows in some of my glossaries and it will take forever to
paste the words in front of the existing words.

Any ideas how I can do this quicker? So basically, I need to paste the word
<Spanish> in front of every word in the second column and the word <English>
in front of every word in the third.

Thanks in advance

 

[Guest]

Hi!

You could try something like: ="<Spanish>"&B1
copy -> paste special -> values

Neil Greenough skrev:

 

[Jim May]

Use col 4 and 5 to create

 

[Jim May]

temporarily Use Col 4 (and 5 in the same way) to
in cell d2 enter formula = "<Spainish>" & B2
and copy down. Do the same for the english..
If it looks good afterwards Copy and Paste-Special
Values to "deformularize col 4 and 5;
Then Delete Col 2 and 3.
that's One way...

 

[Neil Greenough]

Thanks for the replies all!

temporarily Use Col 4 (and 5 in the same way) to
in cell d2 enter formula = "<Spainish>" & B2
and copy down. Do the same for the english..
If it looks good afterwards Copy and Paste-Special
Values to "deformularize col 4 and 5;
Then Delete Col 2 and 3.
that's One way...