For example, I have following string
[TABLE="width: 366"]
<tbody>[TR]
[TD="width: 366"]SPLICE 3_CON 195_INTERLOCK_18_BROWN
I am trying to write VBA code to split it into five and put in different columns like:
[TABLE="width: 366"]
<tbody>[TR]
[TD="width: 366"]SPLICE 3 CON 195 INTERLOCK 18 BROWN[/TD]
[/TR]
[TR]
[TD="width: 366"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Any help is appreciated.
[TABLE="width: 366"]
<tbody>[TR]
[TD="width: 366"]SPLICE 3_CON 195_INTERLOCK_18_BROWN
I am trying to write VBA code to split it into five and put in different columns like:
[TABLE="width: 366"]
<tbody>[TR]
[TD="width: 366"]SPLICE 3 CON 195 INTERLOCK 18 BROWN[/TD]
[/TR]
[TR]
[TD="width: 366"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Any help is appreciated.