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]

 

[Fluff]

If you click on the "Subscribed threads" button at the top of the page, it will show you all the threads you're subscribed to.
Then you can look through that list to find the thread

 

[lezawang]

Thanks for your reply. I could not find my previous post! I do not see all my posts, very few of them. Thank you

 

[Joe4]

I could not find my previous post! I do not see all my posts, very few of them.

They are all there (unless you unsubscribe your own threads!).

If you are looking at your Subscribed Threads, at the very bottom of the screen under the Title column is a page selector. You are only looking at the most recent 25, so to see older ones, you have to select other pages.

You can also go to your Profile and click on "Find latest started threads". Here is a link to that listing: https://www.mrexcel.com/forum/search.php?searchid=7864695
Once again, there are multiple pages (this time the page selector is on the bottom right).

 

[lezawang]

Thank you. I tried all pages actually. I noticed at the bottom of the page it says 316 threats but I posted around 600 threats so I do not think I can see all of them. I also went under profile but there I can see even less. Thanks

 

[Joe4]

You only have 697 posts. Note that you can make more than one post per thread (for example, you already have made 3 posts in this 1 thread). So I think 316 threads sounds about right (I seriously doubt that you have over 600, as that would mean that other than the original question, you replied to less than 100 of your threads, and I don't think that is the case).

 

[lezawang]

Thanks for clarifying thread vs post. I can only see on threats from this year 2018. The reset are from 2017, 2016!
My threat was posted on Feb 2018, I remember that.

 

[Joe4]

Thanks for clarifying thread vs post. I can only see on threats from this year 2018. The reset are from 2017, 2016!
My threat was posted on Feb 2018, I remember that.

Then it shouldn't be a problem finding it. Go to page 5 of the link I provided previously, and you will see your threads from February 2018.
https://www.mrexcel.com/forum/search.php?searchid=7865035&pp=&page=5
and look at your "separting text from cloumn" thead from Feb 8.

By the way, it is "thread", not "threat". We ban members for making "threats"!
(a "threat" is defined as "[FONT=&quot]an expression of intention to inflict evil, injury, or damage").[/FONT]

 

[Fluff]

@Joe4
The link you've supplied comes back with

Sorry - no matches. Please try some different terms.

I've come across this in another thread. It seems that only the person who created the search can view the results.
For instance, what happens if you follow this link https://www.mrexcel.com/forum/search.php?searchid=7865040

 

[Joe4]

I've come across this in another thread. It seems that only the person who created the search can view the results.
For instance, what happens if you follow this link https://www.mrexcel.com/forum/search...archid=7865040

Good catch! I did not realize that.

lezawang,
If you click on this link here, which brings up your Profile, then click on "Find latest started threads" and go to the 5th page, you should see the thread I was talking about.