ExcelBanter - Picking out certain data from a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Picking out certain data from a cell (https://www.excelbanter.com/excel-discussion-misc-queries/446016-picking-out-certain-data-cell.html)

Picking out certain data from a cell

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?

Picking out certain data from a cell

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

Quote:

Originally Posted by jade89 (Post 1601651)

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?

<<<<< 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.