| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to find string and remove, but leave the rest of cell conten
Try this link, the values that you see in the macro i.e 52,39 etc are the amount of characters you wish to remove (including spaces) have a play around with it! http://www.excelforum.com/showthread.php?t=566863 Regards, SImon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=569537 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove the Formula but leave the value alone? | New Users to Excel | |||
| find and remove a string of a cell value with comma as delimiter | Excel Discussion (Misc queries) | |||
| remove blanks from a string of chars within a cell? | Excel Discussion (Misc queries) | |||
| finding the first blank cell and then executing rest of macro | Excel Programming | |||
| How do I insert a page break before each change in the cell conten | Excel Programming | |||
![Simon Lloyd[_852_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
