Extract specific text from column and put in a new column

[applesandpears]

Hey all!

I need to search a list in column B of 500 records to find specific words such as"ABC2000000000" The text will always begin with "ABC................." and I would like to extract this whole world from the text string into a new column.
This is not always in the middle or beginning or end.
It could be inbetween other words or numbers or spaces etc - so its not consistent as this data is from a raw file imported into excel.

So I would like to FIND text beginning with"ABC" in column A and then return "ABC123456789000" in Column B. The format will always be "ABC-followed by 12 numbers"

EG
Column A and column B(what I would like to see)
[TABLE="width: 375"]
<TBODY>[TR]
[TD]KOREIABC123456789999 4029227[/TD]
[TD]ABC123456789999[/TD]
[/TR]
[TR]
[TD]RCA ABC000010469597 PBI000010005941[/TD]
[TD]ABC000010469597[/TD]
[/TR]
[TR]
[TD]8990ABC000010480568[/TD]
[TD]ABC000010480568[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL></COLGROUP>[/TABLE]

 

[Robert Mika]

Hey all!

I need to search a list in column B of 500 records to find specific words such as"ABC2000000000" The text will always begin with "ABC................." and I would like to extract this whole world from the text string into a new column.
This is not always in the middle or beginning or end.
It could be inbetween other words or numbers or spaces etc - so its not consistent as this data is from a raw file imported into excel.

So I would like to FIND text beginning with"ABC" in column A and then return "ABC123456789000" in Column B. The format will always be "ABC-followed by 12 numbers"

EG
Column A and column B(what I would like to see)
[TABLE="width: 375"]
<tbody>[TR]
[TD]KOREIABC123456789999 4029227[/TD]
[TD]ABC123456789999[/TD]
[/TR]
[TR]
[TD]RCA ABC000010469597 PBI000010005941[/TD]
[TD]ABC000010469597[/TD]
[/TR]
[TR]
[TD]8990ABC000010480568[/TD]
[TD]ABC000010480568[/TD]
[/TR]
</tbody>[/TABLE]

If always ABC-12:
Excel 2010

	A	B
KOREIABC123456789999 4029227	ABC123456789999
RCA ABC000010469597 PBI000010005941	ABC000010469597
8990ABC000010480568	ABC000010480568

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B1[/TH]
[TD="align: left"]=MID(A1,FIND("ABC",A1),15)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[applesandpears]

Thank you!

What if it could be different text? is there a way of searching for specific words in a column of text and numbers string and return them in another column?

 

[applesandpears]

hi, just tried the forumal and it doesnt work? I have checked the cell references etc?
thanks

 

[applesandpears]

Thank you very much and i have tried the formula and it now works

Also in the cell there are some other numbers that I would like to extract is there a way of adding to this formuala to find other "text" or numbers?

Once again - thanks for reading this and also for replying

 

[Robert Mika]

Thank you very much and i have tried the formula and it now works

Also in the cell there are some other numbers that I would like to extract is there a way of adding to this formuala to find other "text" or numbers?

Once again - thanks for reading this and also for replying

Could you provide few examples and desired result?