You don't seem to be paying attention:
Your 'solution' won't help at all if the data aren't needed for a text file. What if they're simply required that way for feeding into another application, programmatically, without producing a text file? Besides, it's not at all hard to consolidata the data as requested - and outputting to a text file, without saving as csv then replacing commas.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Sorry! When I did read, that csv-file wasn't asked for, I logically assumed that Excel file was needed - because csv-file is a text file. Replace .csv with .txt or with nothing, and you get an ordinary text file.

But after a have make the excel file, wich the information in it, is Semicolon separated, they want me to copy all info in kolumn A and paste it in a notepad sheet and save it as a .csv

So they require there different files. 1) a excel file save as .xlx, where the info looks like a usual excel file, the info in A1 should be in A1. The info in B1 should be in B1 and so on... 2) a "Semicolon separated" file where the info in every raw should be gathered in Kolumn A as below:
A1) name;adress; phone nr;
A2) name;adress; phone nr; and so on... and this file should also be saved as .xlx and the last file they require is 3) the one I did describe above. A notepad file saved as .csv where I copy the A kolumn from file "2" (the "Semicolon separated" file wich is saved as .xlx) and paste it in notepad and saved it as .csv

Nr 1 and 3 is no problem. But how do I do nr 2