About Us

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can excel give value in words of number entered in another cell?	nivedrajesh	Excel Worksheet Functions	4	October 27th 06 02:57 PM
HOW DO CONVERT EXCEL INTO WORDS FORMAT	a	Excel Worksheet Functions	1	July 29th 05 05:54 PM
Convert HTML into an Excel	skydiving99	Excel Worksheet Functions	1	March 18th 05 11:35 PM
How can I convert an Excel file to an Adobe .pdf file by using Ex.	pammoore2000	Excel Discussion (Misc queries)	5	March 15th 05 03:51 AM
how to convert GETPIVOTDATA from excel 2000 to excel 2002...	Need_help_on_excel	Excel Worksheet Functions	1	March 15th 05 01:08 AM