'Reading' data from csv files in .xlsm Workbooks

Hi Folks
I download csv files into .xlsm Workbooks but one of the new Cols will not 'read' when I input a formula using that Col's Cells.
Presumably this is because of some formatting in this new Col?
Is there a method to 'clean' the data, perhaps by using another Col and then running my formulas from that new Col?

Cheers
hammer

btw, the data is always text eg 'FLAT HCAPS QUALIFIERS'

Okay, I just used the standard TRIM formula which appears to work.

Any other comments/suggestions appreciated.

It can be difficult to provide specific suggestions without a sample file.

I will usually resort to using TRIM(), CLEAN(), etc to "clean up the data" (post import) if I have no other option. The usual options I use instead:

1) If I have access to the person, program, app, code that is creating the CSV file, I will first go there and see if I can change how the CSV file is generated so that these "extra characters" are not included in the file in the first place. Importation of a delimited text file into Excel should normally be very straightforward if those "extra characters" are never included in the file.
2) Other times, I will pass the csv file through a text editor. It is usually a fairly simple "find and replace" procedure for a text editor to remove undesired characters from the text file.
3) Other times, I will open the csv file through the "text import wizard", which will allow me to specify multiple characters as the delimiter.

I guess the point that I make is that, when possible, I like to deal with this kind of issue before I bring the file into Excel, rather than after.

Good advice MrShorty- many thanks