=TRIM(LEFT(B50,FIND(" ",B50)-1))
If I had to build a house I would de-forest the country<g
Yeah, but I'll bet you'd have a very sturdy house!
--
Biff
Microsoft Excel MVP
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Looking good Biff
Why can't I do things like that?
If I had to build a house I would de-forest the country<g
Gord
On Thu, 14 Jan 2010 17:09:47 -0500, "T. Valko"
wrote:
Try this...
=TRIM(LEFT(B50,FIND(" ",B50&" ")-1))
|