Hi, briljant code!
I have a question.
Is his VBA script also available to remove listed characters? I want to build a simular script to remove the following characters:[TABLE="width: 8400"]
<COLGROUP><COL style="WIDTH: 48pt" span=175 width=64><TBODY>[TR]
[TD="width: 64, bgcolor: transparent"]Ω[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"].[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"].[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"].[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"].[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]![/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]"[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]#[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]$[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]%[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]&[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]'[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]([/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"])[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]*[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]+[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"],[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]-[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"].[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]/[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]:[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"];[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]<[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]=[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]>[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]?[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]@[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]\[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]^[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]_[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]`[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]{[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]|[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]}[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]~[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]€[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"].[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]‚[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]ƒ[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]„[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]…[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]†[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]‡[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]ˆ[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]‰[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Š[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]‹[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Œ[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]�[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Ž[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"].[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]�[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]‘[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]’[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]“[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]”[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]•[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]–[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]—[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]˜[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]™[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]š[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]›[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]œ[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"].[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]ž[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Ÿ[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"].[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]¡[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]¢[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]£[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]¤[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]¥[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]¦[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]§[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]¨[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]©[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]ª[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]«[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]¬[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]®[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]¯[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]°[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]±[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]²[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]³[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]´[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]µ[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]¶[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]·[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]¸[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]¹[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]º[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]»[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]¼[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]½[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]¾[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]¿[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]À[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Á[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Â[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Ã[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Ä[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Å[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Ç[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]È[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]É[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Ê[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Ë[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Ì[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Í[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Î[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Ï[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Ò[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Ó[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Ô[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Õ[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Ö[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Ù[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Ú[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Û[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Ü[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Ý[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]à[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]á[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]â[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]ã[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]ä[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]å[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]ç[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]è[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]é[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]ê[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]ë[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]ì[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]í[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]î[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]ï[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]ò[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]ó[/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"]ô[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]õ[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]ö[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]ù[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]ú[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]û[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]ü[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]ý[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]ÿ[/TD]
[/TR]
</TBODY>[/TABLE]
Hope you can help me and many thanks in advance..!
rgds, Arno