Get Twitter Handles Easily by changing URLS to @

About this Tutorial

Change Urls to @ using Substitute()

Featured Formulas

Video Transcript

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.
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.
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.
0:33 I'd do equals, uh, substitute Holly. And what am I substitute in subs between B2? Uh, what am I searching for?
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.
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.
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.
1:15 Really easy to get those URLs into add symbols.