I have a column of codes comprised of mostly numbers and one letter (ie 81548323D1). I'm trying to write a code that will lookup the first four digits of the code, then copy/paste only those digits to another column/sheet.

Does any function exist to do this?

Any help is immensely appreciated as this problem has been plaguing me for some time now.

Regards,

Peter