ExcelBanter - Excel convert 1 row 5 words INTO 1 row 5 columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel convert 1 row 5 words INTO 1 row 5 columns (https://www.excelbanter.com/excel-worksheet-functions/43183-re-excel-convert-1-row-5-words-into-1-row-5-columns.html)

Kassie

Excel convert 1 row 5 words INTO 1 row 5 columns

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

--
ve_2nd_at. Randburg, Gauteng, South Africa

"Kristen Kay" wrote:

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 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/comm...et.f unctions

All times are GMT +1. The time now is 11:16 AM.