Nothing goes between the quotes. What the formula is doing is finding all
the characters before a space. The " " represents the space.
************
Anne Troy
www.OfficeArticles.com

"JG" wrote in message
...
On Tue, 18 Oct 2005 00:15:22 +0100, "Bob Phillips"
wrote:

Didn't you ask this question yesterday and get a response?

Yes bob, i asked but not in this ng. it was m.p.e.

not very good at this. your reply was

=LEFT(A2,FIND(" ",a2)-1)

A2, i assume is the cell? tried that.


what goes between the quotation marks?

anyway i tried it, could get it to work