Get Twitter Handles Easily by changing URLS to @

<div>0:00 Hey, so I got all of these Twitter handles, but they're in URL forum. Right. And in order to get the URLs into, um, handles, I want to add an add sign, actually want to go and tweet this right now over on Twitter.<br>0:16 So I want to quickly get just the names alone. And in this case, I only have 1, 2, 3, 4, 5, 6, which is pretty simple to do by hand.<br>0:25 But if I had 10, 20, 30, 40, uh, I w I don't want to do it by hand. So here's how I would do it.<br>0:33 I'd do equals, uh, substitute Holly. And what am I substitute in subs between B2? Search Twitter from Google Sheets

Uh, what am I searching for?<br>0:42 I'm going to be doing quotes, HTTP, HTTPS, colon.com and slash, and what am I going to replace? I'm gonna replace the ad side and let's see what happens.<br>0:56 There we go. I've been Collins, better sheets. Get it done. She go prolific Oak tree, Layla, get more learning over here.<br>1:05 I'm going to post this on Twitter now. So add a little bit more to it, but yeah, posted here on Twitter.<br>1:15 Really easy to get those URLs into add symbols.</div> Sheet Makeover - Google Ad Writer Search Twitter from Google Sheets