Newbie here so please be gentle, especially as i'm no doubt going to ask some damn simple questions!!

I've been given some data in a report where the fileds are seperated by commas. If I try to paste this into an excel sheet so that the columns are all aligned, all of the data gets pasted in the one column and I can't find a way to seperate them out.

What am i doing wrong??

Cheers

Dan