I'm trying to extract the 4 characters before and after the "-" in a cell. I have been successful in doing this for the first, last, and middle instance. However what I need to do is extract these characters for ALL instances and have them report to either a single cell or multiple cells. The end goal is finding the highest number value in the cell. If there's an easier way of doing it.. I'm all ears!
Here's a sample of a few cells:
<tbody>
</tbody>
So for example in the first row the end goal would be to have a cell that simply has 1981 in it. Second row, 2006, etc.
If anyone has any advice I would greatly appreciate it!
Thanks
Here's a sample of a few cells:
<colgroup><col width="770"></colgroup><tbody> </tbody> | |
<colgroup><col width="770"></colgroup><tbody> </tbody> | |
<colgroup><col width="770"></colgroup><tbody> </tbody> | |
<colgroup><col width="770"></colgroup><tbody> </tbody> | |
<colgroup><col width="770"></colgroup><tbody> </tbody> | |
<colgroup><col width="770"></colgroup><tbody> </tbody> | |
<colgroup><col width="770"></colgroup><tbody> </tbody> |
<tbody>
</tbody>
So for example in the first row the end goal would be to have a cell that simply has 1981 in it. Second row, 2006, etc.
If anyone has any advice I would greatly appreciate it!
Thanks