Ok, I did that and the wrong text got moved. What am I doing wrong here?
And the moved text wasn't removed from column A, just copied.
TwitterDirectoryTestBed.xlsx
Edit to add: This is a response to Newdoverman's response
Secondary edit: ChemistB, this is what I got with your string.
TwitterDirectoryTestBed2.xlsx
Last edited by NightSprite; 11-15-2013 at 11:00 AM.
If you don't have a number pad, try this formula
Formula:
=MID(A1, FIND("@",A1), FIND(" ",SUBSTITUTE(A1, CHAR(160)," ")&" ", FIND("@",A1)+1)-FIND("@",A1))
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks