View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default =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))