View Single Post
  #1   Report Post  
Neil Greenough
 
Posts: n/a
Default Inserting extra info into a cell

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

** <SpanishHola <EnglishHello

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