Picking out certain data from a cell

J

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
 
C

Claus Busch

Hi Jade,

Am Wed, 9 May 2012 08:32:06 +0000 schrieb jade89:
#01-034 EAST AVENUE
Click to expand...

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


Regards
Claus Busch
 
Top