Copying & pasting data

[Burt_100]

I am importing data from a vehicle dealer management system and the system does not segerate the data which I need to analyse basially the data is output in the following form

Yaris 1.33 Vvt-i TR 5Dr Rav4 2.2 D-4d Xt-r Dr, </SPAN> <TBODY> </TBODY><COLGROUP><COL></COLGROUP> </SPAN> Toyota Auris Tstopstart VVti TR, </SPAN> <TBODY> </TBODY><COLGROUP><COL></COLGROUP> etc.,I need the excel to separate these values and put them into seperate cells, i.e Auris, Rav-4 etc., (Model) and Xt-r, Tr (Spec) etc Can anyone help with this? I have searched google everywhere but cannot find an answer. Thanks Johnny

<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>

<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>

 

[CSyx]

Burt_100,

If the data is coming in exactly as you typed it...try using Text To Columns with a space as the delimiter.