text-to-column in vba

[lezawang]

Sorry for off topic.
I asked before how to do text to column in vba for a text showing below. I got a reply which worked perfectly but I could not find the post anymore. Any help would be greatly appreciated. They are all in column A

[TABLE="width: 357"]
<tbody>[TR]
[TD]/37562094231 William Cambridge1 London England[/TD]
[/TR]
[TR]
[TD]/18202835983 Kate Middleton1 Paris France[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]/ES17132466486 Felipe Bourbon1 Madrid Spain[/TD]
[/TR]
[TR]
[TD]/28718720328 John Smith1 New York USA 90210[/TD]
[/TR]
[TR]
[TD]/40234729025 William Cambridge2 Tokyo Japan[/TD]
[/TR]
[TR]
[TD]/50502983774/Kate Middleton2 Sydney Australia[/TD]
[/TR]
[TR]
[TD]/GB57463387310/Harry Windsor2 London England[/TD]
[/TR]
</tbody>[/TABLE]

 

[lezawang]

Found it!! thank you thank you for the help. So happy I found my threaD. sorry for spelling before