Spreading one cell to 4 or 5 columns

[dankar]

[TABLE="width: 500"]
<tbody>[TR]
[TD]comments
[/TD]
[TD]serial no.
[/TD]
[TD]model no.
[/TD]
[TD]part no
[/TD]
[TD]date
[/TD]
[/TR]
[TR]
[TD]serial :1235468
model: III-5400
part :tab3gd1
D:05/08/2018
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]56788
III-555
gac56r1
05/08/2018
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Hi All,

Please I need help in this matter.

I have over than 300 rows.

and I have a column of comments with data in each cells that need split the data in it into 4 columns. or 5

so what am thinking some of the comments have the same name in the column

meaning if there is a way to find serial in the comment copy it and paste under the column serial no,find model copy it and paste under model no,find D and put it under date ,etc.

and to highlight the cells with any color just to know what was pasted because some of the comments does not have the serial,part,model or D in it..which I will handle later (which will be not highlighted)

can some one help find a way to this..even if we can make it column by column

thank you

 

[dankar]

I just want for now to match what in the column with the one in the comments and paste that information under each column..this will be great of help (the data after the ":" )
-if the word serial available in the comments to copy it and paste it under serial (the data after the ":" )
-if the word part available in the comment to paste it under part no (the data after the ":" )
-if the d available to paste the date under date. (the information after ":")

 

[dankar]

Am trying to delete this post..but i cant..please ignor it..thank you.