Welcome to the Q&A Forum

Hi Carole,

Thank you for your help. Before I can use a pivot table, I first need to split the columns with the data to different columns. How do I do that? I now have things like 'no,no no no no no, in one cel..

Lonneke

Hi!

I am trying to find out how I make my CSV report neat, so I can interprete the report.

I know have a CSV report with just numbers and text all in one column. I tried the button text to columns but that doesn't work because when I do that at column A it overwrites column B in which I have the same problem!

Thanks