Text position,remove and replace(inex? substitute?)

[damian_lee]

Hi Masters/Sifu,

I have a question where I need to allocate "@" in an email address and I need to remove text after that and replace with something else:

For Examples:
likeaboss@boss.com
likeadude@dude.com
likeabrother@brother.com

I need to index the "@" and remove the text after that and replace with "likeIcare.com". so, it will become:

likeaboss@likeIcare.com
likeadude@likeIcare.com
likeabrother@likeIcare.com

any suggestion for this noob.

regards

 

[Ingolf]

@Rick,

Vidar posted a slightly incorrect formula... I think this is what he meant to post.

=LEFT(A2,SEARCH("@",A2)+2)&"likeIcare.com"

@Vidar,

Sorry, my mistake. It should look like this.
=LEFT(A2,SEARCH("@",A2)+1)&"likeIcare.com"

Edit: Just noticed that Rick commented this.

Correct formula is: =LEFT(A2,SEARCH("@",A2))&"likeIcare.com"