Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
?? Extra blank lines in 'address' cell after exporting to Excel | Excel Discussion (Misc queries) | |||
Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions | |||
how do i get excel to see info in one cell, look at info in anoth. | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel |