Bigger Problem

[N1KO]

Having got all my e-mail addresses into "[email protected]" 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 [email protected]
111 [email protected]
111 [email protected]
111 [email protected]
111 [email protected]
111 [email protected]
111 [email protected]
111 [email protected]
111 [email protected]
111 [email protected]
111 [email protected]
111 [email protected]
112 [email protected]
112 [email protected]
112 [email protected]
112 [email protected]
112 [email protected]
112 [email protected]

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 = [email protected],[email protected],[email protected], [email protected],upto 250
characters.

A3 = 111
B3 = [email protected],[email protected],[email protected],upto 250 characters

A4 = 112
B4 = [email protected],[email protected],[email protected], [email protected],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