Change Delimiter For CSV in MS Excel

Go to Control panel and select Region and Language.




















Click on additional settings.

Change the List separator value from comma to the separator you want to use.In this case "|" is used.