Associate
I've got a table of codes like this:
666
15
15
704
and I need excel or access to automatically convert the data into the full codes like this:
EUK00666
EUK00015
EUK00015
EUK00704
Some sort of autocomplete option that works backwards, or a macro I could run that would update them all?
Any help will be much appreciated.
666
15
15
704
and I need excel or access to automatically convert the data into the full codes like this:
EUK00666
EUK00015
EUK00015
EUK00704
Some sort of autocomplete option that works backwards, or a macro I could run that would update them all?
Any help will be much appreciated.