separate cells

[Miloud]

hi
when i copied data from text to excel it becomes all in one cell ,how can i separate in deferent cells ,file attached

[JBeaucaire]

Highlight the dataset
Click Data > Text To Columns > Delimited > Next> Space > [x]Treat consecutive delimiters as one > Next > [x]Do not import the first column > FINISH

[Miloud]

Done Thanks

[DonkeyOte]

Just a heads up... after using Text to Columns it's often best to highlight one cell and re-run Text to Columns but un-check all the additional delimiters you set last time be it space, comma etc...

If you don't do this you will find that if you subsequently copy & paste data into the same file (during the same session) XL will try and be "helpful" and repeat the same process during the paste, that is to say XL will delimit the pasted values automatically per your prior delimiters which can obviously be irritating ... so if you repeat the Text to Columns on one cell whilst un-checking the delimiters you will find that obviously it will not alter that cell's value but it will prevent XL from being "helpful" when it comes to future copy/paste actions.