Identifying non numerical headers

[Freddiecrypto]

Hi there and happy newyears!

What I have here is essentially a word document that we'v taken and copy-pasted all the information into excel. We currently use a macro that is identifying all the information and then seperating everything into each column. The one thing that the macro is not doing, and also what I can't seem to fix is the following:

All underlined text needs to be identified as a heading and have its own row (just like "Voltages" in column H, although it's listed as "Information" in column "K" which is weird). After it's identified as a heading it also needs to automatically update this in column "K" - where it should say "Heading".
I also need the underlined text to appear in column "F". So essentially it's both in column "H" and "F" on the same row.

The macro we are currently using was not written by me and trying to solve this has litteraly become mission impossible. Help would be greatly appreciated!

	A	B	C	D	E	F	G	H	I	J	K	L	M
Heading 1	Heading 2	Heading 3	Heading 4	Heading 5	Name
1 Introduction	Introduction	Heading
1 Introduction	Requirement 1.	xxxxxxxxxx	Requirement
1 Introduction	1.1 Reference	Reference	Heading
1 Introduction	1.1 Reference	Requirement 2.	xxxxx	Requirement
2 invoke document	invoke document	Heading
2 invoke document	Information
3 Requirements and conditions	Requirements and conditions	Heading
3 Requirements and conditions	Requirement 3.	xxxxx	Requirement
3 Requirements and conditions	3.1 Devices	Devices	Heading
3 Requirements and conditions	3.1 Devices	3.1.1 general	general	Heading
3 Requirements and conditions	3.1 Devices	3.1.1 general	voltages	Information
3 Requirements and conditions	3.1 Devices	3.1.1 general	Requirement 4.	xxxxx	Requirement
3 Requirements and conditions	3.1 Devices	3.1.1 general	Requirement 5.	xxxxx groundfrequency	Requirement
3 Requirements and conditions	3.1 Devices	3.1.1 general	Requirement 6.	xxxxx dimensions	Requirement
3 Requirements and conditions	3.1 Devices	3.1.1 general	Requirement 7.	xxxxx	Requirement
3 Requirements and conditions	3.1 Devices	3.1.1 general	Requirement 8.	xxxxx	Requirement
3 Requirements and conditions	3.1 Devices	3.1.1 general	Requirement 9.	xxxxx incoming measurement	Requirement
3 Requirements and conditions	3.1 Devices	3.1.1 general	Requirement 10.	xxxxx	Requirement
3 Requirements and conditions	3.1 Devices	3.1.1 general	Requirement 11.	xxxxx security	Requirement
3 Requirements and conditions	3.1 Devices	3.1.1 general	Requirement 12.	xxxxx formclass increments	Requirement
3 Requirements and conditions	3.1 Devices	3.1.1 general	Requirement 13.	xxxxx assisting voltage	Requirement
3 Requirements and conditions	3.1 Devices	3.1.1 general	Requirement 14.	xxxxx electricalbinder	Requirement
3 Requirements and conditions	3.1 Devices	3.1.1 general	Requirement 15.	xxxxx doorcontrol	Requirement
3 Requirements and conditions	3.1 Devices	3.1.1 general	Requirement 16.	xxxxx	Requirement

<tbody>
[TD="align: center"]1[/TD]

[TD="bgcolor: #A9D08E"]Reqnr[/TD]
[TD="bgcolor: #A9D08E"]Primary text[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #A9D08E"]Documenttitel[/TD]
[TD="bgcolor: #A9D08E"]Artifacttype[/TD]
[TD="bgcolor: #A9D08E"]Identifier[/TD]
[TD="bgcolor: #A9D08E"]parentBinding[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: right"][/TD]

[TD="align: right"]100[/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]101[/TD]
[TD="align: right"]100[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]102[/TD]
[TD="align: right"]100[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]103[/TD]
[TD="align: right"]102[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]104[/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]105[/TD]
[TD="align: right"]104[/TD]

[TD="align: center"]8[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]106[/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]107[/TD]
[TD="align: right"]106[/TD]

[TD="align: center"]10[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]108[/TD]
[TD="align: right"]106[/TD]

[TD="align: center"]11[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]109[/TD]
[TD="align: right"]108[/TD]

[TD="align: center"]12[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]110[/TD]
[TD="align: right"]109[/TD]

[TD="align: center"]13[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]111[/TD]
[TD="align: right"]109[/TD]

[TD="align: center"]14[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]112[/TD]
[TD="align: right"]109[/TD]

[TD="align: center"]15[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]114[/TD]
[TD="align: right"]109[/TD]

[TD="align: center"]16[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]116[/TD]
[TD="align: right"]109[/TD]

[TD="align: center"]17[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]117[/TD]
[TD="align: right"]109[/TD]

[TD="align: center"]18[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]118[/TD]
[TD="align: right"]109[/TD]

[TD="align: center"]19[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]120[/TD]
[TD="align: right"]109[/TD]

[TD="align: center"]20[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]121[/TD]
[TD="align: right"]109[/TD]

[TD="align: center"]21[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]123[/TD]
[TD="align: right"]109[/TD]

[TD="align: center"]22[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]125[/TD]
[TD="align: right"]109[/TD]

[TD="align: center"]23[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]127[/TD]
[TD="align: right"]109[/TD]

[TD="align: center"]24[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]129[/TD]
[TD="align: right"]109[/TD]

[TD="align: center"]25[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]131[/TD]
[TD="align: right"]109[/TD]

</tbody>

Mall​

 

[Freddiecrypto]

I just noticed that the titel is somewhat missleading. Perhaps "Identifying underlined text" or something along those lines would be more appropriate?
Since I can't edit this thread, perhaps a mod out there seeing this can change it?.. sorry for the inconvenience.

 

[Freddiecrypto]

If this was asking a bit too much then just a macro for identifying all underlined text as heading would suffice. The most important is to separate the primary text with all the X's from the underlined text so they have their own row.

Feedback, suggestions or any kind of help would be highly appreciated.