Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete ascii character 127
How do I write the code to delete ascii character 127,that will always be the
last entry in column A? Number of cells in column A will vary according to incoming data. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete ascii character 127
cells(rows.count,1).End(xlup).ClearContents
-- Regards, Tom Ogilvy "CyndyG" wrote in message ... How do I write the code to delete ascii character 127,that will always be the last entry in column A? Number of cells in column A will vary according to incoming data. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete ascii character 127
Thank You "Tom Ogilvy" wrote: cells(rows.count,1).End(xlup).ClearContents -- Regards, Tom Ogilvy "CyndyG" wrote in message ... How do I write the code to delete ascii character 127,that will always be the last entry in column A? Number of cells in column A will vary according to incoming data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plus or minus character ...Its ASCII value | New Users to Excel | |||
ascii character in custom format | Excel Discussion (Misc queries) | |||
How can i convert an ASCII character to decimal/hex in Excel? | Excel Worksheet Functions | |||
How to: Convert character to ASCII code | Excel Discussion (Misc queries) | |||
Cannot insert extended ascii character | Excel Discussion (Misc queries) |