| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Splitting a cell in a macro?
I have a column of cells that I would like to be able to split
automatically the problem is that there are two possible choices. The cells begin with either Plan A or Plan B. I need to split Plan A after 17 characters and Plan B after 25 characters. Is there a way to write a bit of code that would be able to differentiate Plan A and Plan B in Column C and split them so that Plan A and Plan B stay in Column C but the other bit...0/7 or 30/30 moves into column D? Thanks for any help in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| E2007 - Macro for splitting text and then replacing something | Excel Discussion (Misc queries) | |||
| Macro Assistance (Splitting into new workbook by value) | Excel Discussion (Misc queries) | |||
| splitting cell text using macro | Excel Discussion (Misc queries) | |||
| Macro for splitting a cell | Excel Programming | |||
| Splitting text in cell with Excel 97 VBA macro | Excel Programming | |||
Threaded Mode
