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
