Extracting data from a cell to the right of a comma

**kufta4** · 12-17-2011, 06:57 PM

Can anybody help me out? Thanks.

**tom1977** · 12-17-2011, 07:03 PM

take a look at attachment

**kufta4** · 12-17-2011, 07:35 PM

Thanks, I over looked the fact that I need everything before, or to the left, of the comma in its own cell too. Thank you.

**JBeaucaire** · 12-17-2011, 07:42 PM

Before a comma: =LEFT(A1, FIND(",", A1) - 1)
After a comma: =MID(A1, FIND(",", A1) + 1, LEN(A1))

**kufta4** · 12-17-2011, 07:46 PM

Thank you guys.

Re: Extracting data from a cell to the right of a comma