Mass text isolation and copying

You just want to isolate the handle so there will be no spaces in it. It could appear anywhere in your block of text or is always at the beginning or end?

This should extract that substring

Formula:

Please Login or Register  to view this content.

Does that work for you?

Going by what I could find out about twitter handles, the "@dsfsdfd" starts the message. If that is the case, then this will extract that portion to column B if the text is in column A

Formula:

Please Login or Register  to view this content.

If you need the rest of the text without the "handle" then enter this in column C and copy down.

Formula:

Please Login or Register  to view this content.

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

Okay, some of your spaces are regular spaces (ASCII Code 32) and others are "internet" spaces (Code 160). My formula will only find the regular spaces so we need to replace the internet spaces with regular spaces.

If you have a numberpad, you can use FIND/Replace
Select Column A where your text is.
CNTRL H to open up find and replace window
In the FIND box, on the numberpad, hold down ALT and type 0160
You should see the cursor move to the right as it types the internet space
Then in the Replace box, just put a space
Replace all.

Also, we need to put a space at the end of your string in the formula to avoid that error you got in B2. Modify as so;

Formula:

Please Login or Register  to view this content.

If you don't have a number pad, try this formula

Formula:

Please Login or Register  to view this content.

Once you have what you want in B, Copy and Paste Special > Values to remove the formulas. Then you can clear A

Glad to help

Where is the name in relationship to the handle? Does it move around also?

If the name doesn't have spaces, you could use a similar formula to the ones above. If sometimes it does have spaces and sometimes it doesn't, then it's a bit tougher.