Excel paste formatting

[benjo]

Hopefully someone can help..

I've got a handful of text documents like this that I need to put into Excel, but I need each bit of data in it's own cell.

Does anyone know how to do this either when pasting, or after? Otherwise it's going to take a while to do it manually

Thanks

 

[benjo]

Ah that worked, didn't think of opening the .txt with excel. Thanks!