Excel convert 1 row 5 words INTO 1 row 5 columns

[Kristen Kay]

I have a document that was scanned, converted to Word and now I need it in
excel to have the right formatting. I need to get it back to a format so I
can manipulate it for formulas. Example:

1 row with five words and numbers with a seperation by one space only " ",
needs to be 1 row and five individual columns. Is this possible and if so
how do I accomplish this?

Thanks! respond to [email protected] please.

(Summary: items from row 1 and columns A-G were scanned to a document.
Unfortunately those items pasted into column A only. Therefore seperation
between words and numbers need to be converted. Is this possible?)

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions

 

[Gary's Student]

Select the cells that you want to fragment. Then pull-down

Data > Text to Columns... > then check delimited and next check space as the
delimiter. This will take a sentence in A1 and distribute the words into
cols B,C,D, etc.

 

[Kassie]

Select the cell, then do Data|Text to Columns|Delimited|Space|Finish