Something to be going on with ...
Formulae in Row 13:
HTML Code:
Copy down, and up if you wish.
At the moment, this doesn't split the address or the telephone/fax numbers.
You could do this with Text to Columns, delimited by comma (,) or you can improve the formulae to split the elements out. I don't have time to do that right now ... sorry.
Regards
Bookmarks