Return first word of a text string

[stuartw]

Hi Guys

I suspect there's a formula for this:

How do I return the first word of a text string in another cell?

eg A1 = "Accounting Answers"

Desired result - B1 = "Accounting"

Thanks in advance
Stu

 

[VoG]

Try

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

 

[morleyuk]

=Left(A1,Find(" ",1)-1)

 

[Scott Huish]

Excel Workbook
	A	B
1	Accounting Answers	Accounting
2	Accounting	Accounting
Sheet1