Inline text to footnote

[tomislav1975]

I'm trying to convert inline text that is surrounded by [footnote] and [/footnote] tags into normal footnotes. Can you share some advice?

[macropod]

A footnote requires both a footnote reference in the body of the document and the actual footnote content (which goes in the footnote). So far, your post seems to identify only the footnote content. What indicators are there for the footnote reference?

[tomislav1975]

I have number of footnote as number before [footnote]. Does this help?

[macropod]

In that case, you could use a macro like:

Please Login or Register  to view this content.

Note: the above code will preserve any formatting your footnote text already has.

[tomislav1975]

Thanks for your effort, I have tried it and I got error 5560 "The Find What text contains a Pattern Match expressions which is not valid". In sub line .execute is where code stops.

[macropod]

That will be due to your Windows Regional Settings. Change:
.Text = "[0-9]@[ \[]{1,2}footnote\]*\[/footnote\]"
to:
.Text = "[0-9]@[ \[]{1;2}footnote\]*\[/footnote\]"

[tomislav1975]

I am trying something using http://www.gmayor.com/replace_using_wildcards.htm but I am surely not not advanced user .

[tomislav1975]

You are word master, thank you very, very much . I will give my best to learn from your site and examples. Thanks again

[macropod]

The process I used employs a wildcard Find expression, as per the gmayor site, but you can't use Find/Replace on its own to turn your body text into footnotes.

[tomislav1975]

Thanks again, I could not do it without you

[tomislav1975]

One more thing, if I would like to have numbers added automatically before [footnote] in inline text what would I have to do? Can you suggest code for this? That would be big help for me, now I have to check numbers before placing new ones. This is what I have so far.Thanks

Please Login or Register  to view this content.

[macropod]

For the purposes of the macro I supplied before, it really doesn't matter what the numbers are. For all it cares, they could all be the same or completely random. Indeed, it could even be modified to work without them, just by changing:
.Text = "[0-9]@[ \[]{1;2}footnote\]*\[/footnote\]"
to:
.Text = "\[footnote\]*\[/footnote\]"

If you're wanting to add the numbers for other purposes, though, you could use code like:

Please Login or Register  to view this content.

Note that the above code re-numbers any tagged text you've already numbered, in case you've already done some tagging & numbering, then inserted new tagged text in between.

[tomislav1975]

Thank you very much, I have learned a lot. I really appreciate your time and knowledge.

[macropod]

Post #10 cross-posted at: http://www.mrexcel.com/forum/general...nt-inline.html
For cross-posting etiquette, please read FORUM RULE 8: http://www.excelforum.com/forum-rule...rum-rules.html