+ Reply to Thread
Results 1 to 3 of 3

Copying data adds carriage return to data copied

  1. #1
    Registered User
    Join Date
    01-08-2009
    Location
    Colorado
    MS-Off Ver
    Excel 2007, 2010 PC, 2011 Mac
    Posts
    41

    Copying data adds carriage return to data copied

    I have a simple excel 2010 workbook that does some simple math. I would like to be able to copy the data from cell F2 and paste it into another application (please see attached file). When I copy using control+v or right clicking and choosing copy from the menu the data I get on the clipboard has a carriage return at the end. I have pasted it into wordpad, notepad, and word 2010 that is showing all formatting and there is a carriage return at the end. This seems to happen to any data I copy out of excel. In the workbook attached I put a number in a few of the empty cells (1.00) and copied it and there is the carriage return there also.

    I have also tried =Clean(F2) in another cell with the same results and also =substitute(F2,Char(13),"") with the same results.

    Any ideas?

    I have attached the spreadsheet I am using.

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Copying data adds carriage return to data copied

    Copy it from the formula bar
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    01-08-2009
    Location
    Colorado
    MS-Off Ver
    Excel 2007, 2010 PC, 2011 Mac
    Posts
    41

    Re: Copying data adds carriage return to data copied

    protonLeah,

    Thank you for the quick reply. That does work. I am marking this thread as solved.

    Brian

+ 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