Picking out certain data from a cell

[jade89]

How do i pick out from within a cell those that have a certai
character? In my case, from this cell below: I would like to pick ou
only #01-034.

#01-034 EAST AVENUE

Is there a way to do this

 

[Claus Busch]

Hi Jade,

Am Wed, 9 May 2012 08:32:06 +0000 schrieb jade89:

#01-034 EAST AVENUE

the string in A1, then try:
=LEFT(A1,FIND(" ",A1)-1)


Regards
Claus Busch