How to convert an Excel file into a semicolon delimited text file?

1. Copy a column of cells, and paste them into a row of cells. (transpose)
2. Save the Excel file into a .csv file.
3. Open the CSV file in a text editor. You will see that all the cells are separated by a comma.
4. Replace all the commas by semicolons.