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?