First Word from a Text Field

[Joseph4th]

I am looking for a way to get the first word from a text field, basically all the characters up until the first space.

So, for example, if the target cell reads: "Highborn is a great iPhone game" it would return just the first word "Highborn"

Thanks in advance and I just want to say I love this forum. I'm amazed that except for this one, which I hope isn't as big of a pain as it looks like to me, every Excel question that I've Googled has lead me to the answer here.

-Joseph-
www.working-as-designed.blogspot.com

[davesexcel]

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

[Joseph4th]

That was quick and it certainly works a hell of lot better than what I was trying, guess I was over thinking it.

Although it does not work if the target cell has only one word, I can get around by adding a space to the end of the word to those few exceptions since the target data doesn't matter. I just needed the list of first words for something I am doing outside of Excel.

Thanks again.

-Joseph-
www.working-as-designed.blogspot.com

[Paul]

You could also account for one-word cells using a formula, then not have to add spaces manually. For example:

=IF(ISNUMBER(SEARCH(" ",A1)),LEFT(A1,FIND(" ",A1,1)),A1)