How 2 split multiple emails in one cell separated with a comma?

**johnny1** · 09-03-2010, 04:20 PM

If i have in cell A1 Five email addresses separated by a "," how can i do a formula that it will separate them and it will put the emails in separate cell in the same row.

EX:

A1
[email protected],[email protected],[email protected]

I would like to get:

A1 B1 C1
[email protected] [email protected] [email protected]

Thanks in advance!!

**TMS** · 09-03-2010, 04:22 PM

text to columns with "," as the separator

**johnny1** · 09-03-2010, 05:15 PM

thanks so much

**TMS** · 09-03-2010, 05:42 PM

You're welcome. Thanks for the feedback.

**royUK** · 09-04-2010, 03:37 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

AND READ THE FORUM RULES. YOUR POSTS ARE CREATING TOO MUCH WORK FOR MODERATORS

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save