Save Word 2007 Document into Excel 2007 Worksheet 1

[JohnBates]

hi Office gurus,

I have a Word 2007 document with lines of content such as :
Mar 2008 255 Leonora 185k
(I'm tracking home sales in my neighborhood)

Really should have started out using an Excel worksheet.

How can I save the Word doc as Excel but have it break into another column at each space? i.e. Mar in col1, 2008 in the next column, 255 in the next column ....

Easy for the experts I'm sure.

Thanks for any tips. John

 

[SkipVought]

Hi,

Check out Data > Text to columns..., Delimited -- SPACE -- CHECK > treat consecutive delimiters as ONE

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}