| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Asc(10) character from cell
I have cells with Asc(10) characters in them, however when I press the
Delete key or Clear Contents or make the cell = "" the character still remains in the cell. How can I rid myself of the character using code? I can get rid of it manually by selecting the cell, clicking in the formula bar and back spacing. Any ideas would be appreciated, thanks. -- Regards, Rocky McKinley |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
| TO DELETE ONLY NUMERIC VALUES IN A CHARACTER AND NUMERIC CELL IN | Excel Discussion (Misc queries) | |||
| Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
| how to select the first character in a cell and delete the rest | Excel Worksheet Functions | |||
| Delete special character | Excel Discussion (Misc queries) | |||
Threaded Mode
