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
>
[TABLE="class: MsoNormalTable, width: 584"]
<tbody>[TR]
[TD="width: 347, bgcolor: transparent"] description 1<o
></o
>
[/TD]
[TD="width: 203, bgcolor: transparent"] description 2<o
></o
>
[/TD]
[TD="width: 123, bgcolor: transparent"] Suffix 1<o
></o
>
[/TD]
[TD="width: 107, bgcolor: transparent"] Suffix 2<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] ROLLER<o
></o
>
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] INSIDE HORIZONTAL VISE FIXED JAW<o
></o
>
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] OUTSIDE HORIZONTAL VISE FIXED JAW<o
></o
>
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] OUTSIDE HORIZONTAL VISE MOVEABLE JAW<o
></o
>
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] SAW BLADE GUIDE PLATE ( DOOR SIDE )<o
></o
>
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] SAW BLADE GUIDE PLATE ( GEAR BOX SIDE )<o
></o
>
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] SAW FLANGE ( P.C.D 63)<o
></o
>
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] CENTER COLLAR (FOR SAW BLADE )<o
></o
>
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] PUMP (ST)(RP)<o
></o
>
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] KNURLED SCREW - OUTSIDE HEAT TREAT<o
></o
>
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] BAR FL 1.00X3.00X1.13 ALUM 6061-T6511<o
></o
>
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] SPR CPRSN (BP)<o
></o
>
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] BARLOADER VERT. ROLLER<o
></o
>
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
<o
> </o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
Sample ofthe data I am working with<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TABLE="class: MsoNormalTable, width: 584"]
<tbody>[TR]
[TD="width: 347, bgcolor: transparent"] description 1<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TD]
[TD="width: 203, bgcolor: transparent"] description 2<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TD]
[TD="width: 123, bgcolor: transparent"] Suffix 1<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TD]
[TD="width: 107, bgcolor: transparent"] Suffix 2<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] ROLLER<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] INSIDE HORIZONTAL VISE FIXED JAW<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] OUTSIDE HORIZONTAL VISE FIXED JAW<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] OUTSIDE HORIZONTAL VISE MOVEABLE JAW<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] SAW BLADE GUIDE PLATE ( DOOR SIDE )<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] SAW BLADE GUIDE PLATE ( GEAR BOX SIDE )<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] SAW FLANGE ( P.C.D 63)<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] CENTER COLLAR (FOR SAW BLADE )<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] PUMP (ST)(RP)<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] KNURLED SCREW - OUTSIDE HEAT TREAT<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] BAR FL 1.00X3.00X1.13 ALUM 6061-T6511<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] SPR CPRSN (BP)<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 347, bgcolor: transparent"] BARLOADER VERT. ROLLER<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TD]
[TD="width: 203, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)