How to seperate a text group in once cell into many cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have uploaded a list to Excel but every row's information is in only one
cell and i cant do anything with it.
How can i seperate the text in one cell into a few cells without manually
cutting and pasting every cell? The most important thing is the emaill
addresses. They have to be seperated...
Exp of a cell:
(e-mail address removed);"johnsmith";"000";"2005-09-16"
Thanks
Nuray
 
Back
Top