<div>
<div class="content wysiwyg-content">
Hello, trying to build a formula or macro to perform the following:<br />
In Column A, find KQSA<br />
Then in that column, find the letters &quot;TK&quot;, then extrapolate the two digit number before it. &nbsp;IF there is no TK, then 0.
</div>
</div>


Hello, trying to build a formula or macro to perform the following:
In Column A, find KQSA
Then in that column, find the letters "TK", then extrapolate the two digit number before it.  IF there is no TK, then 0.

Find and Sort Data

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