×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Hello evryone, There was a post

Hello evryone, There was a post

Hello evryone, There was a post

(OP)
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   

RE: Hello evryone, There was a post

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.

RE: Hello evryone, There was a post

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.

RE: Hello evryone, There was a post

(OP)
Thanks, mate!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Resources

Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close