I Need to separate the item # / from the description in column A? I have about 2000 rows. Once the number is removed I need to place that number in Column B next to the description.
Ex.
A
<tbody>
</tbody>2 6120067 / CABLE EKG SPLB 5 LEAD 2-PRONG SAFETY 700-0008-06
<tbody>
</tbody>
<tbody>
</tbody>
Ex.
A
1 4986238 / SHOE ORTHOWEDGE FOREFOOT OPEN TOE OL-M |
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
Last edited: