Having got all my e-mail addresses into " format i now need to
sort them into a single cell. This cannot be more than 250 characters long.
The e-mail addresses need to be sorted by code.

Addresses:


Code E-mail
111
111
111
111
111
111
111
111
111
111
111
111
112
112
112
112
112
112

I need the e-mail addresses to be put into 1 cell, with the code in say A2
and the e-mail addresses in B2. I need them seperated by commas. I also need
B2 to be no more than 250 characters. If it is i need the rest of the e-mails
to be put in B3 up to 250 characters and the code to be put in A3.

Once all the e-mail addresses have been put in a list then i need the start
on the ones with a different code.

Example:

A2 = 111
B2 = , ,upto 250
characters.

A3 = 111
B3 = ,upto 250 characters

A4 = 112
B4 = , ,upto 250
characters

No spaces.

I'm having real trouble doing this,

If it was in macro code it'd be preferable although any help would be
appreciated!

Thanks N1KO