+ Reply to Thread
Results 1 to 5 of 5

How to stop inverted commas during copy

  1. #1
    Registered User
    Join Date
    07-26-2010
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    41

    How to stop inverted commas during copy

    Hi all,

    I am just wondering if there is a way to stop the inverted commas from the beginning and end of a text copied from excel to a email, notepad etc as this is extremely annoying. I would prefer a very simply way of doing this as I do not yet fully understand the macro system so this would most likely be too much jargon unless the macro is explained and simply.

    I would appreciate a fast reply on this if possible please as I am trying to complete a project and it's driving me crazy.

    Thanks.!

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: How to stop inverted commas during copy

    Please explain a bit more for easy understanding.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    07-26-2010
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: How to stop inverted commas during copy

    Erm, I am not sure what other explanation I can give as I thought I had explained it.

    When I type the following in a excel cell >>>>>> Hello, When do we eat?
    And then copy that and paste it in Word, Email or notepad it then appears >>>> "Hello, When do we eat?"
    I do not want the inverted commas to appear during copy as I don't even know why they appear.

    Hope this explains it.

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: How to stop inverted commas during copy


  5. #5
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: How to stop inverted commas during copy

    Hello jediknight,

    In excel use
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    function and the paste in Notepad
    it will work.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1