+ Reply to Thread
Results 1 to 2 of 2

Copy pasting from Excel issue - NEW LINE/LINE BREAK

  1. #1
    Registered User
    Join Date
    09-07-2012
    Location
    Gothenburg, Sweden
    MS-Off Ver
    Excel 2003
    Posts
    3

    Copy pasting from Excel issue - NEW LINE/LINE BREAK

    Hi,

    So, I've made this wonderful Excel Spreadshet with URLs which I need to manually insert into my CMS tool.

    And, as I try to CTRL+C a selected cell with the URL, and try to paste it into the CMS(or anywhere else) the copied text always ends up with a line break at the end of it.

    Is there anyway to fix this? I just don't want that line break after the copied text!

    Thanks so much in advance for all the help,
    Dennis

  2. #2
    Registered User
    Join Date
    08-17-2012
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    82

    Re: Copy pasting from Excel issue - NEW LINE/LINE BREAK

    Hello,

    You can use for instance the LEFT formula together with the LEN, removing that last space you don't want.

    Please Login or Register  to view this content.
    Then copy paste special values.

    Tough is only something you can do after and not before the copy using CTRL+C.


    Kind Regards,
    FCarv

+ 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