Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Plus or minus character ...Its ASCII value Srinivasulu B[_2_] New Users to Excel 6 September 20th 09 06:44 AM
ascii character in custom format Mike K Excel Discussion (Misc queries) 2 October 20th 06 02:51 PM
How can i convert an ASCII character to decimal/hex in Excel? Surekha Excel Worksheet Functions 1 June 8th 06 08:01 PM
How to: Convert character to ASCII code efernandes67 Excel Discussion (Misc queries) 1 January 21st 06 04:07 PM
Cannot insert extended ascii character Jeff Eckermann Excel Discussion (Misc queries) 1 October 7th 05 06:04 AM


All times are GMT +1. The time now is 10:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"