<div>
<div class="content wysiwyg-content">
<a href="https://filedb.experts-exchange.com/incoming/2016/03_w13/1087819/Capture.JPG" target="_blank" title="Capture.JPG (59 KB)"><img alt="Capture.JPG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2016/03_w13/800_1087819/Capture.JPG" /></a><br />
Hi what formula could I use to fill out the year from column B only if my Column NK does not end with a letter please ?
</div>
</div>


Capture.JPG



Hi what formula could I use to fill out the year from column B only if my Column NK does not end with a letter please ?

Excel Formula how to populate a coloumn only if the field does not end with a letter

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