Extarcting a username from a list of tweets

Hello Excel Friends,

I have a list of tweets, and I would like to extract just the username found within the tweet. I'm not sure if a formula is the best way to do this, or possibly a macro, which is why I'm posting in the general forum. I don't have any experience in coding, but I'll willing to learn, if only you guys can point me in the right direction.

The example I've attached is only of 18 tweets, but the spreadsheet I'm looking to use this on is 100,000+ tweets, so I need something easily scalable. One thing to note is that a tweet can have more than oneuser mentioned in it, such as the first tweet in the example.

Thanks in advance for all help, I greatly appreciate it!
Tweet Example.xlsx

Try the attached

Thanks jindon for your help!

I've been trying to modify this macro to add one small step, and I can't figure it out. Any help is greatly appreciated.

The tweets have a date attached, in column C. And I want to keep transfer that to the new worksheet too. I've attached a revised file to show the "new" current and desired format.

Thanks!!!

You mean like this?

Please Login or Register  to view this content.

Originally Posted by jindon

You mean like this?

Exactly! I can't wait till I can finally figure this stuff out on my own! Thanks for your help!!!

Note:

I just realized that when I break the data into smaller chunks, like 3,000 rows at a time, and run the macro on each individual chunk, it runs fine. It just comes up with the error when I try and run it on all 17,000 rows at once.

Hopefully that helps as a clue to help me solve this!

The macro has been working perfectly, so thanks for the help Excel Forum!!

I have one small question. How would I change this code to also create a row for tweets that do not mention anyone? Right now, a row is just created if a tweet has an "@username", but I would also like to create a row if there is no one mentioned. The first column would have the tweet author, and the second column would just be blank. I've been trying to figure it out for awhile, but I can't seem to get it. Thanks for the help!!

Originally Posted by jindon

You mean like this?

Please Login or Register  to view this content.

See if this is what you wanted.

Please Login or Register  to view this content.

Amazing. Absolutely perfect!! Thank you so much!!!

You are welcome.

Originally Posted by jindon

You are welcome.

jindon - what part would I edit to include more rows like column C (date)? also, is it possible to make this start at row 2, so it doesn't wipe out my column headers? If not, no big deal, as I can add them back in after the usernames are extracted.

This should add the header in the result, but I don't understand the rest.
If you upload the file with your desired result, it may help to understand.

Please Login or Register  to view this content.