Excel Formula to Remove Everything After the First Space

[OilEconomist]

Thanks in advance and I will give feedback on whether it works or not.

I have cell entries with more than one word and I would like to extract only the first word. For example

First Word Only = First

I tried to use

=LEFT(A2, FIND( "^^", SUBSTITUTE( A2," ","^^",LEN(A2)-LEN(SUBSTITUTE(A2," ",""))))-1)

But it would give me everything except after the first space. The formula gave me "First Word"

 

[OilEconomist]

Sorry for not responding sooner. Will test this weekend and get back to you.

Yes from a hyperlink and it gets the first word and second word, but leaves all the rest off. Strange.

 

[Michael M]

Hmm, works for me.
Can you post a small set of sample data, with what you want extracted ?

 

[OilEconomist]

Hi Michael M, I apologize for not responding sooner. I will see if I can post a small sample data set when I get a chance.