BanhdaTr0n
New Member
- Joined
- Jun 16, 2021
- Messages
- 7
- Office Version
- 365
- 2019
- Platform
- Windows
Hi,
I have a problem when extracting some word that is between some characters. Such as between "@" and ":". The last character could be other character like "#", "$", ...
I have tried some solutions but only can extract the first word but not the rest.
It would look something similars to this.
I really preciate if there are any formulas or VBAs that can help on this
I have a problem when extracting some word that is between some characters. Such as between "@" and ":". The last character could be other character like "#", "$", ...
I have tried some solutions but only can extract the first word but not the rest.
It would look something similars to this.
I really preciate if there are any formulas or VBAs that can help on this
| mradamjack.csv | |||
|---|---|---|---|
| A | |||
| 1 | @wabisabi1977: Tower25 update https://t.co/YGJPGmgG16 #comicsReadToday #comictalk #addiction #drama #InkedVerse @mradamjack https://t.co… | ||
| 2 | @wabisabi1977: New Tower 25 at https://t.co/UOYb6rnA2r @mradamjack @topwebcomics @supportcomics @best_webcomics #comics #ink #art http… | ||
| 3 | @wabisabi1977: Tower25 grabbed a spot on the Top10 #drama #comics list https://t.co/2VEGyRzRNK @thepulpmediaUS @comicbookgirl_ @mradamja… | ||
| 4 | @wabisabi1977: #new Tower25 pgs up https://t.co/EtBZau5jjZ #comics #art #recovery PLZ RT @topwebcomics @mradamjack @comicbookgirl_ https… | ||
| 5 | @wabisabi1977: 2new tower25pages up @ https://t.co/2LN5PpGPaW @mradamjack @topwebcomics @supportcomics #NCBD #comics #survival | ||
| 6 | @wabisabi1977: New Tower25 pgs up https://t.co/uaOOvWx03B plz rt #ncbd #ink #art @Kingghidorah64 @topwebcomics @mradamjack @jimwhiffen1 … | ||
Sheet1 | |||
