Extract string within tags

[swaggerbox]

In E:\test folder, I have several text files. Each text file contains several datasets. What I need to do is extract the string within and tags and output these to Excel. The extraction part gives me so much difficulty. Is there a simple way to extract the string within these tags?

[Bob Phillips]

If youy lookup Instr in VBA help you will find this finds the position of a nominated string (Character), so you can use this in conjunction with Left or Mid to extract between tags.