Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hidden character in Excel
I don't know if this will help in your situation but in VBA if I am trying to
ascertain what an unprintable character code is then I run code something like the following. Need Intermediate window open (View Intermediate window or Ctrl/G). Sub ChrCodes() Dim i For i = Len(ActiveCell.Value) To 1 Step -1 Debug.Print Asc(Mid(ActiveCell, i, 1)) Next i End Sub If using Find/Replace then enter the character to find using the Alt key and Numeric key pad. Enter the character code as 4 digits with leading zeros. Leave the Replace field blank. I didn't check the ASCII codes you posted to see if there is a tab there but that is possibly the character you are looking for. -- Regards, OssieMac "SaveTheMonarchButterflies" wrote: 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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
hidden character in Excel
Not sure, could be 3, 25 or 30 to separate the data.
"SaveTheMonarchButterflies" om 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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
hidden character in Excel
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
Hidden Character | Excel Worksheet Functions | |||
hidden character in string | Excel Programming | |||
Hidden Character Find Macro Help | Excel Programming | |||
How do I delete hidden character in Excel? | Excel Discussion (Misc queries) |