On Mon, 7 Nov 2005 23:17:12 -0000, "workaholic" wrote:

I have a long list on words (below) in the next column i have this
=LEFT(F1,LEN(F1)-FIND("=",F1)-2)
The result is in the second list below, as you can see it's not right. No's
3, 5, 7, 8, 9, 10, 15, 18, 20, 22, 23 are in correct.

Any ideas what happening here?


Try:

=TRIM(LEFT(F1,FIND("=",F1)-1))

--ron