# ISO macro **URL:** \ **Category:** Uncategorized\ **Created:** [August 7, 2006, 9:33am UTC](https://forum.kirupa.com/t/iso-macro/196274 "2006-08-07T09:33:16Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![RageW0lf](https://avatars.discourse-cdn.com/v4/letter/r/e495f1/32.png) [@RageW0lf](https://forum.kirupa.com/u/RageW0lf)\ **Post date:** [August 7, 2006, 9:33am UTC](https://forum.kirupa.com/t/iso-macro/196274/1 "2006-08-07T09:33:16Z")
I am in search of a macro to sort addresses into a certain format when I get from Paypal. I download my history in excel format, and then usually copy and paste addresses into notepad. I need to have them line by line, seperated at the comma: for example - Joe Bloggs, 158 bloggs street, bloggs town, BR56 6TG, United Kingdom would become: Joe Bloggs 158 bloggs street bloggs town BR56 6TG United Kingdom Ideally I need something to do all addresses like that. It doesn’t have to be from notepad, if it could do each part of the address in a seperate excel field that would work. I currently press Return ALOT to get them in the right format - takes a while when you have several hundred to do every day. I know you can do macros in excel, and I tried but I got stuck as I have never studied VB and have no intention of doing so as I am finsihed with web design! I would very grateful to anybody who knows of a macro that could help me. Thanks