Bigger Problem

[N1KO]

Having got all my e-mail addresses into "(e-mail address removed)" 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 (e-mail address removed)
111 (e-mail address removed)
111 (e-mail address removed)
111 (e-mail address removed)
111 (e-mail address removed)
111 (e-mail address removed)
111 (e-mail address removed)
111 (e-mail address removed)
111 (e-mail address removed)
111 (e-mail address removed)
111 (e-mail address removed)
111 (e-mail address removed)
112 (e-mail address removed)
112 (e-mail address removed)
112 (e-mail address removed)
112 (e-mail address removed)
112 (e-mail address removed)
112 (e-mail address removed)

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 = (e-mail address removed),[email protected],[email protected], (e-mail address removed),upto 250
characters.

A3 = 111
B3 = (e-mail address removed),[email protected],[email protected],upto 250 characters

A4 = 112
B4 = (e-mail address removed),[email protected],[email protected], (e-mail address removed),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