Welcome to the community
What activity are you using to copy?
Generally we read the whole data as A2:A might not be valid input range of excel related activities…so read A:A into datatable and generally on clipboard the value would be like with new characters so use string.join(environment.NewLine,dt.AsEnumerable.Select(function(x) x(0).ToString)) and set to clipboard and use it with ctrl+v to paste on sap..the issue of range also would be gone with this
Cheers