Results 1 to 10 of 10

Thread: Headlines - Three ways to quickly paste unformatted text in Microsoft Office

  1. #1
    HEXUS.admin
    Join Date
    Apr 2005
    Posts
    31,709
    Thanks
    0
    Thanked
    2,073 times in 719 posts

    Headlines - Three ways to quickly paste unformatted text in Microsoft Office

    Does it annoy you when copying and pasting text into Microsoft Word brings with it all sorts of formatting? Here's some quick workarounds.
    Read more.

  2. #2
    Does he need a reason? Funkstar's Avatar
    Join Date
    Aug 2005
    Location
    Aberdeen
    Posts
    19,874
    Thanks
    629
    Thanked
    962 times in 813 posts
    • Funkstar's system
      • Motherboard:
      • Gigabyte EG45M-DS2H
      • CPU:
      • Intel Core2Quad Q9550 (2.83GHz)
      • Memory:
      • 8GB OCZ PC2-6400C5 800MHz Quad Channel
      • Storage:
      • 650GB Western Digital Caviar Blue
      • Graphics card(s):
      • 512MB ATI Radeon HD4550
      • PSU:
      • Antec 350W 80+ Efficient PSU
      • Case:
      • Antec NSK1480 Slim Mini Desktop Case
      • Operating System:
      • Vista Ultimate 64bit
      • Monitor(s):
      • Dell 2407 + 2408 monitors
      • Internet:
      • Zen 8mb

    Re: Headlines - Three ways to quickly paste unformatted text in Microsoft Office

    When copying really completex objects from the likes of Excel, i often have to use Paste Special -> Microsoft Office Excel Worksheet Document or Paste Special -> Picture (Enhanced Metafile)

    Means it's a pain to edit it after, but it's the only way we can get out engineering calculations into our closeout reports for work

  3. #3
    Registered User
    Join Date
    Sep 2006
    Posts
    2
    Thanks
    0
    Thanked
    0 times in 0 posts

    Re: Headlines - Three ways to quickly paste unformatted text in Microsoft Office

    My trick is to paste the text first in notepad and then copy & paste it again to the final application...

  4. #4
    IBM
    IBM is offline
    there but for the grace of God, go I IBM's Avatar
    Join Date
    Dec 2003
    Location
    West London
    Posts
    4,187
    Thanks
    149
    Thanked
    244 times in 145 posts
    • IBM's system
      • Motherboard:
      • Asus P5K Deluxe
      • CPU:
      • Intel E6600 Core2Duo 2.40GHz
      • Memory:
      • 2x2GB kit (1GBx2), Ballistix 240-pin DIMM, DDR2 PC2-6400
      • Storage:
      • 150G WD SATA 10k RAPTOR, 500GB WD SATA Enterprise
      • Graphics card(s):
      • Leadtek NVIDIA GeForce PX8800GTS 640MB
      • PSU:
      • CORSAIR HX 620W MODULAR PSU
      • Case:
      • Antec P182 Black Case
      • Monitor(s):
      • Dell 2407WPF A04
      • Internet:
      • domestic zoom

    Re: Headlines - Three ways to quickly paste unformatted text in Microsoft Office

    yup, me too....and I don't do it often enough to warrent learning a new way of doing it. But thanks anyway
    sig removed by Zak33

  5. #5
    Senior Member Workaholic's Avatar
    Join Date
    Oct 2004
    Location
    Manchester
    Posts
    1,500
    Thanks
    187
    Thanked
    14 times in 12 posts

    Re: Headlines - Three ways to quickly paste unformatted text in Microsoft Office

    Same here, but if its in a table etc it can mess it up very bad.

    Tip3 - what a long way to do it. Stick it in a macro.....
    Woohoo now Assistant Manager!


  6. #6
    Senior Member
    Join Date
    Apr 2005
    Posts
    2,536
    Thanks
    15
    Thanked
    4 times in 3 posts

    Re: Headlines - Three ways to quickly paste unformatted text in Microsoft Office

    First off, thanks HUGELY to Parm for creating the article and associated thread.

    The first tip - using Ctrl+Spacebar to make highlighted text revert to the bodytext format - is VERY interesting to me (as I'll explain in a bit) but not for use in Word.

    I don't need it for the correction of text that's just been pasted into Word cos (in Word 2003, which is what I'm using here), I have set up a toolbar icon to paste in unformatted text - and use that VERY many times a week.

    If anyone wants a quick walk-through of how to set up such an icon, just shout and I'll knock up something and paste it here.

    For those who can't wait, the clue is that you record a macro, drag it to the toolbar and then change its icon to something that might help you to remember what it does.

    No less important to me, I have also set up two formatting toolbar icons in Excel 2003.

    One pastes only the formatting of the copied cell(s); the other pastes in only the value of a copied cell(s).

    These I also find HUGELY useful - and have long used them. Every regular user of Excel that I've help create these icons also loves them.

    Again, if anyone fancies having a walk-through, just shout.

    Now for that Ctrl+Spacebar tip.

    This is a massive thing for me because I've been hugely frustrated that Outlook (I'm using 2003) doesn't have a macro-recording facility. That's meant that I've been unable to create a paste-plain-text button.

    So, I have had two options - neither of which is satisfactory to me.

    The first was to use the Edit menu (Edit > Paste Special > Text), which is a bore.

    Actually, in truth, up until five minutes ago, I didn't even think that Outlook had a Paste Special command!

    That's because I have Outlook 2003 set up to create emails in HTML format and, if that's the case (as Outlook's help just explained to me), that menu option isn't there (likewise if you've chosen plain text emails - but, of course, in that situation, its absence is of no consequence!),

    The menu option is only there if you've set up the program to create emails in Rich Text format.

    To do that, you need to access the Tools menu and then:

    Click Options, click the Mail Format tab and, in the 'Compose in this message format' list, select Rich Text.

    Now, I can understand why the menu option isn't there for plain text but I reckon it's plain dodgy programming that it's not there for HTML.

    Anyway, the inability to paste plain text has been a major bugbear with Outlook because what I've always had to do is paste stuff into a Notepad file, copy it from there and then paste it into the (HTML formatted) email that I'm writing in Outlook.

    But, with the Ctrl+Space keyboard shortcut, all I now have to do is paste stuff into an email I'm creating, highlight it and use the shortcut.

    Sweet!!

    Though not quite as sweet as having a toolbar icon, of course.

    But still a whole lot better than messing around with Notepad!

    And this shortcut works whether you've got your email-creation format set to HTML or to RTF.

    Of course, if you don't have the Ctrl button held down before you press the spacebar, then the highlighted text gets zapped!

    Also, the shortcut doesn't work in WordPad - the text gets zapped even if you do have the Ctrl key held down before pressing the spacebar.

    Bob C

  7. #7
    Senior Member
    Join Date
    Apr 2005
    Posts
    2,536
    Thanks
    15
    Thanked
    4 times in 3 posts

    Re: Headlines - Three ways to quickly paste unformatted text in Microsoft Office

    Just to say again - Parm - MANY thanks!

    Cheers

    Bob

  8. #8
    unapologetic apologist
    Join Date
    Nov 2005
    Location
    UK
    Posts
    1,954
    Thanks
    363
    Thanked
    274 times in 145 posts

    Re: Headlines - Three ways to quickly paste unformatted text in Microsoft Office

    re the pasting: why not simply use the smart tags? fast enough for me........

  9. #9
    Senior Member
    Join Date
    Apr 2005
    Posts
    2,536
    Thanks
    15
    Thanked
    4 times in 3 posts

    Re: Headlines - Three ways to quickly paste unformatted text in Microsoft Office

    Quote Originally Posted by fuddam View Post
    re the pasting: why not simply use the smart tags? fast enough for me........
    Dear Cryptic,

    Care to share you knowledge?

    Mr Ignorant

  10. #10
    unapologetic apologist
    Join Date
    Nov 2005
    Location
    UK
    Posts
    1,954
    Thanks
    363
    Thanked
    274 times in 145 posts

    Re: Headlines - Three ways to quickly paste unformatted text in Microsoft Office

    oh, sorry, lol.

    I meant that if one pastes between / within office apps, the smart tag pops up alongside the pasted item, before you do anything else. Bottom right, PASTE icon.

    Can select paste format from the tag, which usually includes an 'unformatted' option. Is a shortcut to most Paste Special operations.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Microsoft Office 2007
    By Mountain in forum Software
    Replies: 16
    Last Post: 23-04-2008, 11:20 AM
  2. Microsoft office 2003 trial problem
    By tbeck40 in forum Help! Quick Relief From Tech Headaches
    Replies: 2
    Last Post: 11-11-2007, 06:30 PM
  3. Problem with Nero
    By deathsith in forum Help! Quick Relief From Tech Headaches
    Replies: 2
    Last Post: 15-06-2007, 09:24 AM
  4. Open Office Writer - Header Numbering
    By ajbrun in forum Software
    Replies: 3
    Last Post: 07-05-2007, 12:23 PM
  5. Microsoft Office Licences
    By mike_w in forum Software
    Replies: 1
    Last Post: 11-06-2005, 10:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •