Copying the first word of a phrase into a new column (Word or Excel)
Thread poster: Charlie Bavington

Charlie Bavington  Identity Verified
Local time: 21:26
French to English
Jan 9, 2006

[Word & Excel 2002; Win XP]

I have some glossary files consisting of 2 columns, the first column being a source word or phrase, the second being the target translation. For reasons I won't bore you with here, I would like to create a third column containing only the first word of each source phrase (which, of course, since some entries are one word only, may simply consist of that single word, i.e. there is no guarantee that the source phrases are >1 word in length). Note that this operation is to COPY the first word (not CUT), i.e. I wish the first word to remain in the source phrase.

I am happy to carry out this manipulation in either Word or Excel, but would like to automate it as much as is possible.
The two options which seemed most likely were:
a) in Excel, a formula which would take the first word from a cell and copy it to a new cell
b) in Word, a macro (recording keystrokes, rather than VB perhaps?) using Find to locate the first word in a cell in a table and copy it to another cell in the same row. This would be repetitive but still better than doing the whole thing manually.

However, I can't find either a suitable formula in Excel, or a suitable "Find" command in Word which will effectively just copy the first word in a string.

Has anybody got any bright ideas?
Thanks in advance,

Direct link Reply with quote

Hynek Palatin  Identity Verified
Czech Republic
Local time: 22:26
English to Czech
+ ...
Copying the first word of a phrase into a new column (Word or Excel) Jan 10, 2006

In Word:

First, I would add the third (empty) column and convert the table to text, just to make things easier.

The macro would be:

Ctrl-Shift-Right (to select the first word)
Ctrl+C (to copy it)

You could edit the macro to add a loop that would run through the whole document, so that you don't have to run the macro manually for every line.

Also, some words in the third column will contain trialing spaces. You can remove them with one search and replace operation (replace " ^p" with "^p").

In Excel:

Even easier, you can extract the first word with the following formula. I hope I got the English function names right:

=IF(ISERROR(FIND(" ";A1));A1;LEFT(A1;FIND(" ";A1)-1))

A1 is the cell containing the source term.

Direct link Reply with quote

Charlie Bavington  Identity Verified
Local time: 21:26
French to English
Brilliant! Jan 10, 2006

The Excel method works just fine.
You were right about the English function names, although I had to change the ";" into ",", as follows:

=IF(ISERROR(FIND(" ",A3)),A3,LEFT(A3,FIND(" ",A3)-1))

Thank you very much for your help - you have saved me literally hours of work (I did one manually before posting the question, so I know how long it takes!). I'm very grateful.

Direct link Reply with quote

To report site rules violations or get help, contact a site moderator:

You can also contact site staff by submitting a support request »

Copying the first word of a phrase into a new column (Word or Excel)

Advanced search

SDL Trados Studio 2017 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search