Separating data from txt to columns

[kkostas]

I have a txt with meteorological data with station names, longitude, latitude, etc. They are placed in columns, separated by commas, but the padding is done with empty spaces instead of tabs. I want to transfer the data to an excel sheet, but, obviously, they are not placed in separate columns. I was told that I can use Paste special to help me separate the data, but all I see is 2 options (Unicode text and text), none of which does what I want. So, my question has 2 parts.

1. How can I create some "guidelines" to separate the various columns?
2. What is the best way to remove empty spaces? I guess I could use the Replace option to remove them, but I wonder if there is another way?

Thanks

[Tony Valko]

The macro at this website will remove all leading/trailing
and multiple interspersed char 32 space characters.
It will also remove and/or convert char 160 non breaking
spaces into standard char 32 space characters. It will
work on text or numbers and the numbers will be
converted to true numeric numbers.

I use this macro dozens of times every single day!
It's a real time saver.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

[kkostas]

Thank you. I will give it a try. Another way I found is by selecting the column with the text and use the "Text To Columns" option from the Data tab.