On Apr 24, 2:18*am, "JLGWhiz" wrote:
Not sure, could be 3, 25 or 30 to separate the data.

"SaveTheMonarchButterflies"<SaveTheMonarchButterfl wrote in message

...



Can someone tell me what character comes along at the end of a cell of
excel
data when you paste a column of data into another application? I've tried
to
use the vb.net replace *on the data with chr(10), also 13, 9,11,12,13,30,
31,
160, 182, 172, 129, 141, 143, 144, and 157. I haven't hit it so far. The
Excel 2003 functionality of viewing codes (tools - options -
international)
seems to be gone in 2007. Any help would be appreciated.
Thanks!- Hide quoted text -

- Show quoted text -

If you copy excel data to another application (MS Word ) the each row
separated by Asc 13 and column by asc 9
There may be a combination of Asc 10 + asc 13 if any excel was
formatted wraptext=true