Is that data in many columns, or just one?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Navision" wrote in message
oups.com...
Thanks,

but it doesnt work. This is an export file from MBS Navision plans and
it has predifined formulas in excel. And I can not change it in
Navision, maybe only in excel. Example:
Br. racuna GK Ime TC Sifra 1.1.2006 1.2.2006
TROSKOVI POSLOVANJA 40000 72144 6548
TROSKOVI PR & MARKETING I PRODAJE 40000 57828 5689
450 Troskovi oglasavanja 40000 5689 859
451 Troskovi PR-a 40000
452 Troskovi istrazivanja trzista 40000 568
453 Troskovi donacija i sponzorstva 40000 458
454 Troskovi tiska plakata, izrade oglasa 40000 5689
455 Troskovi izrade forspana 40000 56234
456 Fotografiranje,animac.,jinglovi,logotip 40000
457 Institucij.mat.(vizitke,memo,posjet,vre) 40000
Ostali troskovi prodaje i marketinga 40000 0 0
4590 Ostali troskovi prodaje i marketinga 40000 568
4591 Troskovi nagradnih igara-prodaja 40000
4592 Troskovi spikiranja forspana-Yammat 40000

450 is exported txt cell,blanks in first columns are formulas cell..