Splitting up address
Thank you it works great.
"excelent" wrote:
remember select ur adress cells, - and run kode
" skrev:
I suggest you start by recording a macro of you using the text to
columns function and using a space as your delimitor.
From there you can see the code and play with it from there.
Neal wrote:
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.
|