| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Creating Auto Separation of Numbers thru Defining Delimiter
Im trying to write a program where a alphanumeric is typed into a cell A1
(ex. 2345n2375n2938n6475n2938) Once the macro reads this i need the macro to break this down using "n" as a delimiter and out put into B1-5 then automatically return to a1 clear the data in the cell and wait for another number to be inputed the output needs to look like this like this b1 contains 2345 b2 contains 2375 b3 contains 2938 b4 contains 6475 b5 contains 2938 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Parse delimiter is change from text to numbers | Excel Discussion (Misc queries) | |||
| separation of text and numbers in an unmerged cell | Excel Discussion (Misc queries) | |||
| defining names in a macro | Excel Discussion (Misc queries) | |||
| Need importing macro to recognize #*# as delimiter | Excel Programming | |||
| Defining an auto-open macro that prints specific worksheets | Excel Programming | |||
Threaded Mode
