Text Formating

[Wismer]

Hi to all excel lovers,

Since I dont have pdf to excel converter, I have selected all the text from PDF file which contains several comlumns and pasted the data in excel file.

Is there any way that I can format that text so that all the data which is appearing in one cell ( column A) to spread over the rest of the columns from A to onwards.
For example:

215254 JOHNSON, BAKER 1406 Sep 01, 2006 1.00 HOUR 24.70 9011623 1 11 92

The above data appears in one cell. I need to speard them in 12 cells in same row.

Any help greatly appreciated.

Thanks
Wismer

 

[VoG]

Try Data > Text to Columns

 

[onlyadrafter]

Hello,

to continue select Delimited and check the SPACE

 

[Wismer]

Purrrrrr fecccct !!!

thanks
Wismer