dividing a text based on a delimiter(dynamic)

[abishai gray]

i want to create a formula that breaks a list of data (in
my case emails) into sets of ten or twenty. each email is
delimited with commas and all the emails are contained in
one cell that references a column full of singular emails
in singular cells. i am so totally lost. any ideas?

 

[AlfD]

Hi!

Help me.

What exactly does

"all the emails are contained in one cell that references a column ful
of singular emails in singular cells" mean?

Al

 

[Guest]

Here is what happens, I have a cell with

"(e-mail address removed),[email protected],[email protected]"

it goes on and on for a couple of hundred emails in this
manner. I want to find the tenth or twentieth comma and
break the data at that point.

 

[AlfD]

Hi!

Easy way is to separate all of the email addresses into cells of thei
own. You can recombine them as you wish after that. The only caveat i
that there are not more than 256 of them wrapped up in the one cell. I
there are, it is still solvable, so come back if you need to.

Assumptions: the string of email addresses is in cell A1
Cells B1, C1 .... as far as necessary are empty.

Click on A1
Go to Data>Text to columns>delimited>Comma>Finish. This will split th
long list into its components between the commas: one to a cell.

Once you have disassembled the long list you can put it back as yo
wish. Example: put in A2: = A1 &","& B1 &","& C1 . A2 will then hol
the first 3 addresses with commas between them.

Al