| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove all characters before a certain one
is there a way to program a macro to remove all characters before "&" in a
cell, or range of cells? At the same time, if a cell does not contain a "&" to delete the contents. Ex. Mike & Jill would become Jill Mike would be come "" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove characters | Excel Discussion (Misc queries) | |||
| Remove last 10 characters | Excel Discussion (Misc queries) | |||
| Remove first few characters | Excel Worksheet Functions | |||
| Remove top bit characters | Excel Discussion (Misc queries) | |||
| I need to remove characters ... | Excel Discussion (Misc queries) | |||
Threaded Mode
