Extract Twitter Handles Only

[kparadise]

I have cells with alot of text, but each cell contains only one twitter handle. All I want to do is extract the twitter handle without extracting the @ symbol.

I.E.
blah blah @CAT blah blah
Blah @Doggy Blah
Blah Blah Blah @Kyle Blah

RETURN:
CAT
Doggy
Kyle

 

[Alan_P]

Hi kparadise,

Could give this a go...

=MID(A1,FIND("@",A1)+1,FIND(" ",A1,FIND("@",A1))-FIND("@",A1))

 

[Rick Rothstein]

=MID(A1,FIND("@",A1)+1,FIND(" ",A1,FIND("@",A1))-FIND("@",A1)-1)

You need to add the -1 that I show in red above to get rid of the trailing space your original formula retains.

 

[Alan_P]

Thanks Rick! Didn't spot that

 

[kparadise]

Thank you gentlemen.