Range headings

Jan 24, 2023
Reaction score
Hello first,

I am looking for a solution for a while and hope you can help me

Is about it have many headings,
For example

4. heading1
4.1 (4.1)Heading2
4.2 (4.2)Heading2
Text from Heading2

4.3 (4.3) Heading2
4.1.1 (4.1.1) Heading3 ( Heading4

5. heading1
5.1 (5.1)Heading2
5.2 (5.2)Heading2
5.3 (5.3) Heading2
Text from Heading2

5.1.1 (5.1.1) Heading3
5.1.1 ( Heading4

Write Name from heading level 2 with text
((5.3) Heading2)
in excel and ignore the others

Is there a way to run through all heading 2 and find out if this text has
I only want to write headings that contain text (of course this also applies to headings 1 - 4) into excel.

It would already help to find out the range of this heading level

4.1 (4.1)Heading2
4.2 (4.2)Heading2
(Range heading2 4.2)
Text from Heading2
(End Range heading2 4.2)

4.3 (4.3) Heading2
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question