| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro or formula to get rid of a number
is there a formula that i can drag or macro that allows me to get rid of
specific digits? Example data: 20 1191 88018 1514 119411 119147 11551123 119146 I need to get rid of all "11" that are in the beginning, however, not if they are at the end or in the middle. So the data would look after editing like: 20 91 88018 1514 9411 9147 551123 9146 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to repeat a formula a set number of rows apart | Excel Discussion (Misc queries) | |||
| macro to repeat a formula a set number of rows apart | Excel Discussion (Misc queries) | |||
| countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
| Random number Macro | Excel Discussion (Misc queries) | |||
| Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
Threaded Mode
