MS Access / Excel

( |-| |2 ][ $ · 5 Jul 2007 at 12:35

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.

wonder_lander · 5 Jul 2007 at 12:49

If you have the data "666" in excel in column A1 then in B1 use the following formula =LEFT("EUK00000",8-LEN(A1))&A1

A[L]C · 5 Jul 2007 at 13:52

nice little formula there

( |-| |2 ][ $ · 5 Jul 2007 at 16:30

Yes that works great thanks. I wonder if I can push my luck and ask for a last question.

converting numbers stored like this:

6.6.07
18.6.07

into date format 06/06/2007?

s-p · 5 Jul 2007 at 21:28

( |-| |2 ][ $ said:
Yes that works great thanks. I wonder if I can push my luck and ask for a last question.

converting numbers stored like this:

6.6.07
18.6.07

into date format 06/06/2007?

Assuming data "6.6.07" is held in the cell A1, use the following TEXT(SUBSTITUTE(A1, ".", "/"), "DD/MM/YYYY")