I have textin column B that is 5 to 50 characters long and need to split the text up totwo columns of 30 and not split a word the fun part is that in column B I needto pull out 2 characters to column D and E that are in brackets (AB) first setto D and second to E. Any help will be appreciated <o></o>
<o> </o>
Sample ofthe data I am working with<o></o>
<tbody>
</tbody><o> </o>
<o> </o>
Sample ofthe data I am working with<o></o>
description 1<o></o> | description 2<o></o> | Suffix 1<o></o> | Suffix 2<o></o> |
ROLLER<o></o> | |||
INSIDE HORIZONTAL VISE FIXED JAW<o></o> | |||
OUTSIDE HORIZONTAL VISE FIXED JAW<o></o> | |||
OUTSIDE HORIZONTAL VISE MOVEABLE JAW<o></o> | |||
SAW BLADE GUIDE PLATE ( DOOR SIDE )<o></o> | |||
SAW BLADE GUIDE PLATE ( GEAR BOX SIDE )<o></o> | |||
SAW FLANGE ( P.C.D 63)<o></o> | |||
CENTER COLLAR (FOR SAW BLADE )<o></o> | |||
PUMP (ST)(RP)<o></o> | |||
KNURLED SCREW - OUTSIDE HEAT TREAT<o></o> | |||
BAR FL 1.00X3.00X1.13 ALUM 6061-T6511<o></o> | |||
SPR CPRSN (BP)<o></o> | |||
BARLOADER VERT. ROLLER<o></o> |