View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neal Neal is offline
external usenet poster
 
Posts: 63
Default Splitting up address

How would I write a macro that would split up an addrss by spaces? Lets say
the address is 1364 W elm street apt #4? I am new to coding so I dont know
where to start. Also I need the macro to run down the list until there is no
address to move.
Any help would be greatly appreciated, thanks Neal.