breaking single cell into individual cells so i can find

Hi

To split the data you can use the Data/text to columns feature and select space as the delimiter.

If you have a great deal of data to enter you could try the following. Browsers deal with copying and pasting a little differently and Explorer will usually give the result that you experienced. Often using Firefox the same data copied and pasted will arrive correctly in Excel, it may be worth trying.

Regards

Jeff