joeloveszoe
Board Regular
- Joined
- Apr 24, 2014
- Messages
- 102
- Office Version
- 365
- Platform
- MacOS
<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>
<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>
<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>
<tbody>
</tbody>
(removing space and commas)
is there a quick way to do this (with one formula)
thanks so much for your help!
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>
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!