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

 

[izzop]

Can't you just open it through Excel?

Not able to try it at the moment, but Excel used to open up an import wizard, you could then import it as tab delimited.

Regards

 

[benjo]

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