A trick before converting CSV file into Excel worksheet. Since CSV file is just a normal text file, you can just replace any occurrence of a delimiter with a substitution:
For example:
replace delimiter | with |' or
replace delimiter , with ,'

since Excel will treat any ' in front of a CSV element into a left-justified text.

If the CSV file is too big in size, instead of using the standard Windows Notepad, use Notepad++ (available on the Internet) which can handle such text files to perform the substitution.

This post has been edited by eclectice: Dec 27 2017, 10:25 PM