I have been working on table in excel for the purposes of analyzing stocks, and have run into an issue that should be fairly straight forward. I am trying to take a string of text and compare it to a stock symbol. If the symbol is found in the string I would like it to populate the first column of my table.
Table 1
<tbody>
</tbody>
Table 2
<tbody>
</tbody>
Basically, I want to populate column A of Table 2 with the stock symbol found as part of the string in Column B. I have tried various references, but haven't gotten it to work properly. Alternatively, if there is a way to simply have a formula in Column A remove all the numbers and the letter C from the string in Column B and leave the remaining letters that would work as well. Any help would be much appreciated! The difficulty I have found is the varying length of the stock symbol in Column B complicates the process of simply taking the first 4 characters in the Column to populate Column A.
Thanks for any help!
Table 1
JAZZ | 179.73 |
DIS | 110.12 |
BA | 141.85 |
YHOO | 43.31 |
<tbody>
</tbody>
Table 2
JAZZ |
<tbody> </tbody> | |
<tbody> </tbody> | ||
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody>
</tbody>
Basically, I want to populate column A of Table 2 with the stock symbol found as part of the string in Column B. I have tried various references, but haven't gotten it to work properly. Alternatively, if there is a way to simply have a formula in Column A remove all the numbers and the letter C from the string in Column B and leave the remaining letters that would work as well. Any help would be much appreciated! The difficulty I have found is the varying length of the stock symbol in Column B complicates the process of simply taking the first 4 characters in the Column to populate Column A.
Thanks for any help!