Cell Trim Help

[Serge77]

Hello everyone. Not sure if this is possible but here is my question. I have a list of (900+ rows) of xxxxxxxxx@yyy-bbb-ccc.txt and the "x" = user names so varies in lengh and all different. Is there a way to remove everything upto "yyy-bbb-ccc.txt"? I can replce ".txt" with replace tool because it is same in all cells but not the user names.

Thank you

[jmulqueen]

You could try

=MID($A1,(FIND("@",$A1)+1),10000)

Assuming your data starts in A1. and copy down. Does that work?
This also assumes no data is longer than 10000 characters

[Norie]

You could use Data>Text to columns with @ as the delimiter.

On the 2nd step choose not to import the first column.

To remove the .txt you could repeat text to columns but with . as the delimiter and choosing not to import the second column.

[Serge77]

You could try

=MID($A1,(FIND("@",$A1)+1),10000)

Assuming your data starts in A1. and copy down. Does that work?
This also assumes no data is longer than 10000 characters

Genius. Thank you so much that worked.

[Serge77]

You could use Data>Text to columns with @ as the delimiter.

On the 2nd step choose not to import the first column.

To remove the .txt you could repeat text to columns but with . as the delimiter and choosing not to import the second column.

Thank you for Replying Norie. I didn't try it because jmulqueen solved it for me.