How to pick 1st word

[Salamullah]

Hi

I want a formula to pick 1st word from the sentence , please help



Jack & Jill = Jack
Please come = Please
Gross Margin = Gross

 

[mikerickson]

try
=TRIM(LEFT(SUBSTITUTE(A1, " ", REPT(255," ")), 255))

 

[jtakw]

Hi,

If the 1st word is Always defined before the 1st space:

Book1
	A	B
1	Jack & Jill	Jack
2	Please come	Please
3	Gross Margin	Gross
Sheet709

Cell Formulas
Range	Formula
B1	=LEFT(A1,FIND(" ",A1)-1)

 

[Peter_SSs]

Edit: Ooops, hadn't seen jtakw's post.
However, I've included an extra bit so it still returns the first word even if there is only 1 word in the cell.

.. or just
=LEFT(A1,FIND(" ",A1&" ")-1)

 

[Salamullah]

Thank all of you all formulas are ok to use

 

[Peter_SSs]

Thank all of you all formulas are ok to use

You're welcome.

 

[jtakw]

You're welcome.