Hello evryone, There was a post

Hello evryone,

There was a post towards the end of the last thread which answared one of my questions but I have many more!

If i have a table of data in an EXCEL worksheet and want to copy it over to WORD or WORDPAD (an editor) what do I have to do to have it appear like regular text i.e. with just one space between the words or numbers. When I attempt this the line in the word document sort of gets split up in to columns up in the ruler bar....

To clarify, say if I have spelled the sentence " I am an Excel novice" in a row of cells with each word in one cell how is this sentence copied to an editor to look just like it would if you typed it in Word??
Saving the Excel sheet as a CSV (or CVS,i dont remember)will put comas between words(I have just learned that!!)

I will appreciate any all the help i can get,

Thank You :->

 

[ivymike]

you could try using "paste special" instead of "paste" when you insert the text into word (under the Edit menu). Try "plain text." I don't know for sure whether or not that'll do it for you, but it's worth a try.

 

[austim]

This seems to work for me, copying text from Excel into Word:

1. Select cells in Excel, and click Edit - Copy
2. Click on location in your Word document where you wish to place the text.
3. Click Edit - Paste special - Formatted text (RTF)

That gets you to where you started off with your problem - the text is pasted into your document as separate cells in a Word table.

Now comes the cunning part

4. Select the newly pasted table of text.
5. Now on the Table menu click Convert Table to text.
6. A little screen appears, asking you what character you wish to use to separate the individual text cells instead of the column boundaries. Select 'other', and enter a space character where prompted.

That should be it.

Note - I do not claim any real knowledge behind this posting - ivymike invented the use of paste-special, Word Help told me the rest when I tried 'convert table to text' in the Find field.

 

Thanks, mate!