View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SaveTheMonarchButterflies SaveTheMonarchButterflies is offline
external usenet poster
 
Posts: 4
Default hidden character in Excel

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!