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
<tbody>
/37562094231 William Cambridge1 London England...