Thanks! I'll try it next time. VG

"arno" wrote:

Hi,

now that you know that your vanilla fills up fields with blanks and
that the size is 6 characters you know what to do in your vlookup: fill
up your match kriteria (in a1) with blanks like:

=vlookup(left(a1&" ", 6), table, column, false)

(there's a repeat function that could repeat a " " 6 times, I do not
recall the name in english right now...)

you do not need to remove the blanks from your csv-file, so don't do
it, leave your data what it is.

arno

ps. knowing the field descriptions of tables make the difference