<div>
This is great! Now I just need to ask another question on how to pull multiple INCxxxxxxxxx from a cell. I will just ask another question.
</div>


This is great! Now I just need to ask another question on how to pull multiple INCxxxxxxxxx from a cell. I will just ask another question.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I exported emails from outlook to an excel file. I want to pull a specific value such as INC08110011 from each cell in column A and display it in column B. The INCxxxxxxxx can be between other text so that is my dilemma.<br />
<br />
Column A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Column B<br />
Look into Ticket INC08110011 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; INC08110011<br />
check INC08120011 today &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; INC08120011 &nbsp;<br />
<br />
<br />
Above is what I want done extract just the INCxxxxxxxx from column A and display it in column B
</div>
</div>


Hi,

I exported emails from outlook to an excel file. I want to pull a specific value such as INC08110011 from each cell in column A and display it in column B. The INCxxxxxxxx can be between other text so that is my dilemma.

Column A                                                 Column B
Look into Ticket INC08110011                 INC08110011
check INC08120011 today                       INC08120011  


Above is what I want done extract just the INCxxxxxxxx from column A and display it in column B

How do I extract a value that is between other text in Excel and have it display in another cell.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.