In Microsoft Office Excel you can join multiple string from cells by using the Concatenate function. Like this: =CONCATENATE(E2,”-“,F2) Here the string from the cell E2, the character “-” and the string from F2 will be joined together. Making a final result looking like this: “7-42”.
In Microsoft Office when saving an Excel file to CSV file, Excel doesn’t ask if we have to care about encoding, in particular, a major problem occur with characters is being replaced with other symbols like square, star etc. Want we want is to save Unicode in UTF-8. There is a solution, not the prettiest but it