seperating fields - excel

[xirokx]

Hi,

is there a way to seperate fields in excel?

so for example:-

COLUMN A COLUMN B COLUMN C ETC ETC
MR APPLE APPLES, APPLE ST APPLE LANE, APPLETON APPLE11111

So I wanna seperate column b so "apple st" will go into a new column and the same for column c...

I have a 1000 to do..

pls help

thanks in advance..

 

[xirokx]

but i need the finished version to be in excel??

i dont quite get how creating a notepad file will enable me to put it in a spreadsheet format seperated by fields?

pls clarify

thanks