Opening CSV files with automatic 'text to columns'

[turdferguson]

Hello, I have a problem when opening CSV files and the data is all jumbled. I would like to open the file and have the data sorted like 'text to columns' but without doing it manually. I did create a macro to remove the delimiter but I need to simplify the process even more.

Any help is appreciated!