Delete everything before a certain character?

**seansks** · 01-14-2010, 04:02 PM

Hi, I was hoping someone could help me with this. How can I delete everything before a certain character (for this example: @ ), no matter how much there is before @ in each cell. Thank you.

**Richard Buttrey** · 01-14-2010, 04:10 PM

Hi,

Without resorting to macros there are a couple of options.

1. Select the whole of the range in questions then do an Edit Find and enter *@ then click Repace All without specifying any replacement.

2. In an adjacent cell to the cells in your list use the formula

Code:

=RIGHT(A1,LEN(A1)-SEARCH("@",A1)+1)

and copy down your list.

HTH

**Paul** · 01-14-2010, 04:11 PM

Hi Seansks, and welcome to the forum.

This may work for you (assumes the cell with text is A1, change as needed):

=RIGHT(A1,LEN(A1)-FIND("@",A1)+1)

This keeps the @ symbol. If you want to get rid of that and just keep what comes after the symbol just remove the +1 on the end.

**darkyam** · 01-14-2010, 04:13 PM

Deleted: didn't read Richard's response in full.

**zbor** · 01-14-2010, 04:15 PM

Or this:

=REPLACE(D7,1,FIND("@",D7,1),"") (without @)
=REPLACE(D7,1,FIND("@",D7,1)-1,"") (with @)

**seansks** · 01-15-2010, 09:49 AM

Originally Posted by Richard Buttrey

Hi,

Without resorting to macros there are a couple of options.

1. Select the whole of the range in questions then do an Edit Find and enter *@ then click Repace All without specifying any replacement.

2. In an adjacent cell to the cells in your list use the formula

Code:

=RIGHT(A1,LEN(A1)-SEARCH("@",A1)+1)

and copy down your list.

HTH

Thanks to everyone who responded, beyond appreciated. I tried out Richard's example and it worked perfectly. thanks a bunch, saved me a bunch of time on a project!