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

#01-034 EAST AVENUE

Is there a way to do this?

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

<<<<< HELP from BRAZIL

Dear JADE89, Good Morning.

Suppose your data is on A1 cell.

Then at B1 cell put this:
=IF(MID(A1,1,8)="#01-034 ",REPLACE(A1,1,8,),A1)

Take a look at it and tell me if it worked for you.
Fell free to ask anything about your question.

If it is not what you are looking for, please, show us an example of the workbook to make it easier to understand the issue?
Attach it here.

Have a nice day.