MS Access / Excel

Associate
Joined
18 Oct 2002
Posts
1,748
Location
Chesterfield
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.
 
Back
Top Bottom