Excel 2007 : Pasting Data from excel to textbox has newline attached

**TimeVampire** · 02-23-2011, 01:35 PM

This appears to be a design issue in excel, when you multi select a column or data set, it is going to separate each cell by a newline so that it will paste neatly into another table.

This is an issue because I have a data lookup tool, when i sort out data and copy and paste into the program, there is a little space (represents the newline I assume) attached to the end of the data that I have to manually remove each time. There is no "space" in the excel data if i double click the data. I think this is simply just attached to the cell data I believe as a normal function of excel.

I'm curious if there is any setting I change in excel or any code I can run to have it only copy the cell data minus the newline?

**MarvinP** · 02-23-2011, 04:24 PM

Hi TimeVampire and welcome to the forum,

I hope you aren't sucking my time away without having a real question or problem.

To text your assumption of the last character being a NewLine, pull it into Word and turn paragraph marks on. Click on the backward P character in word. This will show what character it really is.

That will be a start for figuring out your problem.

**TimeVampire** · 02-24-2011, 12:14 PM

That appears to the be the case then. I was able to reproduce what you described with the markings. I typed into a blank document "Hello I am a cell" and copied it into word.

Attached a picture for fun reference. Also thanks for the welcome

.