Hi Woodle2,

Excel's Text to Colums feature uses the delimiter (a comma ?) to decide
where to split the initial address data.


---
Regards,
Norman



"wood1e2" wrote in
message ...

Ok thanks...but how does the macro know the correct length of what I am
cutting and pasting...
for example, the first line of the address to move is ten letters long,
and the next address has a 15 letters log...therefore the macro will cut
ten letters of the 15 letter address? or not? :)


--
wood1e2
------------------------------------------------------------------------
wood1e2's Profile:
http://www.excelforum.com/member.php...o&userid=32971
View this thread: http://www.excelforum.com/showthread...hreadid=527990