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

Hi!

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

Neil Greenough skrev:

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

Use col 4 and 5 to create
"Neil Greenough" wrote in message
...
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

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" wrote in message
...
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

Thanks for the replies all!


"Jim May" wrote in message
news:xZHIe.7448$MZ6.1955@lakeread01...
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" wrote in message
...
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