Blog Archives

Excel Join Character Strings From Multiple Cells

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

Posted in Tips and Tricks, Windows Tagged with: , , ,

Excel CSV And Unicode UTF-8 Character Error

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

Posted in ErrorFix, Windows Tagged with: , , ,