How to separate ; in Excel

HI,

Thank you for you answare.

But I will give you more detail. I have this:

Knr;Knaam;KStraat;KHuisnummer;KPostcode;KposcodeLetter;KPlaats;KRekeningnummer
1;De Vries;Abc Straat ;1;6446;AH;Brunssum;9756234512
2;De Vries-De Wit;Acaciastraat ;3;6444;CC;Brunssum;9756234512
3;Jansen;Acaciastraat ;5;6444;CD;Brunssum;5646453678
4;Van Stappen;Acaciastraat ;7;6444;CE;Brunssum;8573262343
5;Flaton;Acaciastraat ;9;6444;CG;Brunssum;5399486760
6;Aghina;Acaciastraat ;11;6444;CH;Brunssum;9756233312
7;Blaauw;Adenauerstraat ;10;6441;JV;Brunssum;9756233312

And in the above row you see Knr;Knaam and in the oter rows you see: 1;De Vries..etc

Now it is 1 long string seperated by ; but I want to have it in Seperate columns so: Knr(column ), Knaam(column), .. etc.

Thank you.