hel separating

[joeloveszoe]

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}table.t1 {border-collapse: collapse}td.td1 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #cbcbcb #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}</style>[TABLE="class: t1"]
<tbody>[TR]
[TD="class: td1"]6260B012AA
[/TD]
[/TR]
[TR]
[TD="class: td1"]0453C001M
[/TD]
[/TR]
[TR]
[TD="class: td1"]0263B001AAM
[/TD]
[/TR]
[TR]
[TD="class: td1"]3500B001AAM
[/TD]
[/TR]
[TR]
[TD="class: td1"]9435B001AAM
[/TD]
[/TR]
[TR]
[TD="class: td1"]J9833, 310-6640, 310-7660, GC502
[/TD]
[/TR]
[TR]
[TD="class: td1"]330-9523, 7H53W, 330-9524, P9H7G, 2MMJP
[/TD]
[/TR]
[TR]
[TD="class: td1"]310-5402
[/TD]
[/TR]
[TR]
[TD="class: td1"]310-5404, W5389, 12A8302, X203H22G, X340H22G
[/TD]
[/TR]
[TR]
[TD="class: td1"]310-8702, 310-8709, PY449
[/TD]
[/TR]
[TR]
[TD="class: td1"]E250X22G, 310-8710, MW685, 39V1645, OD3500
[/TD]
[/TR]
[TR]
[TD="class: td1"]310-7945, RF223
[/TD]
[/TR]
[TR]
[TD="class: td1"]330-4130, P578K, 330-4131, P579K
[/TD]
[/TR]
[TR]
[TD="class: td1"]DM254, 330-2664, 330-2647
[/TD]
[/TR]
[TR]
[TD="class: td1"]330-2666, DM253, 330-2649, 330-2667, RR700
[/TD]
[/TR]
[TR]
[TD="class: td1"]330-2666HY, DM253HY, 330-2649HY, 330-2667HY, RR700HY
[/TD]
[/TR]
[TR]
[TD="class: td1"]330-2666SHY, DM253SHY, 330-2649SHY, 330-2667SHY, RR700SHY
[/TD]
[/TR]
[TR]
[TD="class: td1"]E260X22G, 330-8988, DM631, 39V3207
[/TD]
[/TR]
[TR]
[TD="class: td1"]330-2209, NX994, HX756
[/TD]
[/TR]
[TR]
[TD="class: td1"]331-0611, R2W64
[/TD]
[/TR]
</tbody>[/TABLE]

this is a sample of my data within a series of cel
some cells have multiple part number (separated by a comma) and soem cells simply have one
i'd like to find a easy was to separate each part number into its own cell
for example

330-2209, NX994, HX756
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 8.0px Helvetica; color: #424242}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}table.t1 {border-collapse: collapse}td.td1 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #cbcbcb #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}</style>[TABLE="class: t1"]
<tbody>[TR]
[TD="class: td1"]330-2209
[/TD]
[TD="class: td1"]NX994
[/TD]
[TD="class: td1"]HX756
[/TD]
[/TR]
</tbody>[/TABLE]
and
330-2666SHY, DM253SHY, 330-2649SHY, 330-2667SHY, RR700SHY
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 6.0px Helvetica; color: #424242}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}table.t1 {border-collapse: collapse}td.td1 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #cbcbcb #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}</style>[TABLE="class: t1"]
<tbody>[TR]
[TD="class: td1"]330-2666SHY
[/TD]
[TD="class: td1"]DM253SHY
[/TD]
[TD="class: td1"]330-2649SHY
[/TD]
[TD="class: td1"]330-2667SHY
[/TD]
[TD="class: td1"]RR700SHY
[/TD]
[/TR]
</tbody>[/TABLE]


(removing space and commas)
is there a quick way to do this (with one formula)

thanks so much for your help!

 

[Fluff]

You can do that with "Text to columns" on the Data tab.
Selct the column with your values, Select Text to columns, Delimited, Next, Check "Comma" & uncheck any others, Finish

 

[JoeMo]

With Text to Columns, if you check both Comma and Space as delimiters the results will not contain any leading spaces that might not be noticeable, but can throw off any calculations that might refer to the cell contents.

 

[Fluff]

Good point Joe.
I'm so used to using it with numbers I forget that the spaces are left with text.

 

[joeloveszoe]

With Text to Columns, if you check both Comma and Space as delimiters the results will not contain any leading spaces that might not be noticeable, but can throw off any calculations that might refer to the cell contents.

thanks so much for you help!

 

[joeloveszoe]

thanks for the help!

 

[Fluff]

Glad we could help & thanks for the feedback