Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to remove all characters in a cell after the first word. Anyone know how to do this?

share|improve this question
up vote 2 down vote accepted

If you assume that a space is the division between words you can use something like this.

=LEFT(A1,FIND(" ",A1,1))

if you have a sentence with a comma after the first word it will return it as well, however. You can insert this in an adjoining cell and paste the result. or if you want a macro to do that, it is fairly simple to adapt.

share|improve this answer
2  
You might also want to add -1 to avoid trailing space, i.e. =LEFT(A1,FIND(" ",A1)-1) – barry houdini Jul 3 '12 at 9:47

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .