This function worked perfectly for what I needed to do. Thank you very much for your help.

Thanks for the reply. The non-numeric can be anything not just 'K'.