Help with Formula extracting data from a single cell into different separate cells

[Marconet]

I have a database that I receive from a program called spreadsheet Converter. On receiving the email, I get the PDF File as well as an excel.csv file, and on opening it I get the following:

"Cape Town","N/A","N/A","[email protected] ","0841234567 ","Yes","N/A","N/A","N/A","N/A","EC1","EC1","Yes","Yes a Toyota corolla ","ILS jump bag","Yes portable ","N/A","No","Freelance ","Always just let me know before hand I lots of events, freelancing as a events safe officer ","Disaster management volunteer for 15 years plus and doing and planning events ","Worked in the EMS field for more than 20 years, went to work in Iraq for 2 months, till doing volunteer work and doing freelance work, I'm always interested in meeting people and exchange knowledge ","0","105.226.15.229","2/22/2015 11:51:04 AM"

So now I want to put all of the above, currently appearing in ONE cell, and split them into various difference cells. Example:

Cell A1 - I want "Cape Town"
Cell A2 - I want "N/A"
Cell A3 - I want "N/A"
Cell A4 - I want "[email protected]"

and do forth and so on........... what formula function do I use to do that? I'm somewhat frustrated!

[sktneer]

If you have only one such string in A1, with the help of excel built in features you can easily achieve that.
Please find the attached workbook and see the sheets named as Steps to know the process to do that easily.

[AlKey]

Or you can just use a formula assuming the text string is in A1

Place formula in any cell and pull it down.

=TRIM(MID(SUBSTITUTE(","&$A$1,",",REPT(" ",1000)),1000*ROW(1:1),1000))