Hi All;
I am hoping someone can help me with VBA

I am currently importing an XML file into Excel for upload into another application.
However sometime some of the tag we need are missing. It is always in the same column "AM"

For example the correct format should be "In-work <tagname>$6,000</tagname>AmountNeed/<tagname>$12,000</tagname> Setup"

what we often get is
"In-work <$6,000</tagname>AmountNeed/<tagname>$12,000</tagname> Setup"
Or
"In-work <tagname>$6,000AmountNeed/<tagname>$12,000</tagname> Setup"

Or any combination where the tagname are missing.

I need a code to check only column AM each row with data and if tagname missing add it.
The tag name must be in the correct place.


Thanks in advance for any help you can provide.

DenFlow