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>

6260B012AA

0453C001M

0263B001AAM

3500B001AAM

9435B001AAM

J9833, 310-6640, 310-7660, GC502

330-9523, 7H53W, 330-9524, P9H7G, 2MMJP

310-5402

310-5404, W5389, 12A8302, X203H22G, X340H22G

310-8702, 310-8709, PY449

E250X22G, 310-8710, MW685, 39V1645, OD3500

310-7945, RF223

330-4130, P578K, 330-4131, P579K

DM254, 330-2664, 330-2647

330-2666, DM253, 330-2649, 330-2667, RR700

330-2666HY, DM253HY, 330-2649HY, 330-2667HY, RR700HY

330-2666SHY, DM253SHY, 330-2649SHY, 330-2667SHY, RR700SHY

E260X22G, 330-8988, DM631, 39V3207

330-2209, NX994, HX756

331-0611, R2W64

<tbody>
</tbody>

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>

330-2209

NX994

HX756

<tbody>
</tbody>

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>

330-2666SHY

DM253SHY

330-2649SHY

330-2667SHY

RR700SHY

<tbody>
</tbody>

(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