View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GammaRuit GammaRuit is offline
external usenet poster
 
Posts: 8
Default 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