| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that deletes the last character in a cell
I have an 18,000 record database and every entry is a name with the
letter A added to the end. for example: Lastname, firstname A . I need a macro that will open the cell, backspace the "A" out of there, close the cell for editing, moves down one record or line and loops back to editing the cell and removing the A. This was simple in Lotus but I'm not a programmer and I really don't want to spend 20 hours hitting, F2, Backspace, enter. Does anyone have a simple solution. I do know how to set up a macro in Excel but that's about it. Thanks ...TJ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro deletes row in range, macro then skips the row moved up | Excel Discussion (Misc queries) | |||
| Macro that deletes rows from cell containing End to end of data. | Excel Discussion (Misc queries) | |||
| Macro that deletes every third row....+ | Excel Discussion (Misc queries) | |||
| Macro that deletes certain rows and not others | Excel Programming | |||
| hitting spacebar in excel deletes last character entered. | New Users to Excel | |||
![TJ[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
