[SOLVED]Isolating parts of a cell

**Torenko** · 12-10-2011, 04:15 AM

I recently got an info spreadsheet. The problem is that the emails in the spreadsheet are bunched together with other bits of info instead of being separated into their own individual cells.

Here's a portion of what I'm talking about: http://i44.tinypic.com/a5j9jn.jpg

Question: Is there a way to mass delete everything past the first comma in each cell (I only want to keep the email addresses)? If so, how do I go about doing it?

**dilipandey** · 12-10-2011, 04:34 AM

Hi Torenko,

If you have all your data in Column A, apply the following formula in B1 and drag it down :-

=LEFT(A1,SEARCH(",",A1)-1)

Another way could be to use "Text-To-Column" feature of Excel where you can divide data based on commas.

Let the forum know if this is not enough to tackle the issue.

Regards,
DILIPandey
< click on below 'Star' if this helps >

**Torenko** · 12-10-2011, 05:32 PM

I couldn't figure out how to properly apply the formula, but the alternative you suggested (Text-to-Column) did exactly what I needed. Thank you very much! My dad was going to separate the data manually one by one (lol) but I knew there had to be a quicker way. Again, thanks a lot, you saved us a ton of time.