| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro to edit and delete one character in a cell
Can anyone please help.
I am trying to write a very simple macro that will just edit a cell and delete the last chracter. Example: I have a column with the following numbers: 1234 5678 9032 I want a macro that I can just convert each cell to the following: 123 567 903 Therefore, stripping the last digit. I don't even mind if it splits the cell into two so the end result is: 123 4 567 8 903 2 Thank, David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| macro to copy and edit then delete a worksheet | Excel Discussion (Misc queries) | |||
| Delete Asc(10) character from cell | Excel Programming | |||
| How to run my macro on Insert-Rows , Edit-Delete | Excel Programming | |||
Threaded Mode
