Can you copy from a dynamic range, then amend some text and then convert it into an XML?

[TheSimscard08]

Hey Can anyone help?

I have data of varying lengths that I need to manipulate then convert into XML.

I'd need to delete some data, change some data and then convert the data to XML.

So I would have:

this text would need to be deleted START; abc jbghjj xyz abc k huhihuih xyz abc ihihihih xyz abc 656565 xyz ;STOP this text would also need to be deleted

The red text at the beginning and end would need deleting, the bold brown text would need changing from abc to < and xyz to >

This would all then need be saved as an XML file.

If anyone can help me out I'd appreciate it.

Thanks.

 

[TheSimscard08]

Anyone?