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

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
If your data starts in A2 then maybe:

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

Here is another formula you can try...

=REPLACE(A2,FIND("@",A2),99,"@likeIcare.com")

If your data starts in A2 then maybe:

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

the result not consistent:

 likeaboss@boss.com likeaboss@likeIcare.com likeadude@dude.com likeadude@likeIcare.com likeabrother@brother.com likeabrother@likeIcare.com myneighbour.freak@freaky.com myneighbour.likeIcare.com myniece.icecreamelolly@sweet.com myniece.icelikeIcare.com

<colgroup><col><col></colgroup><tbody>
</tbody>

Here is another formula you can try...

=REPLACE(A2,FIND("@",A2),99,"@likeIcare.com")

so far the result is consistent:

 likeaboss@boss.com likeaboss@likeIcare.com likeadude@dude.com likeadude@likeIcare.com likeabrother@brother.com likeabrother@likeIcare.com myneighbour.freak@freaky.com myneighbour.freak@likeIcare.com myniece.icecreamelolly@sweet.com myniece.icecreamelolly@likeIcare.com

<colgroup><col><col></colgroup><tbody>
</tbody>

the result not consistent:

 likeaboss@boss.com likeaboss@likeIcare.com likeadude@dude.com likeadude@likeIcare.com likeabrother@brother.com likeabrother@likeIcare.com myneighbour.freak@freaky.com myneighbour.likeIcare.com myniece.icecreamelolly@sweet.com myniece.icelikeIcare.com

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

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

the result not consistent:

 likeaboss@boss.com likeaboss@likeIcare.com likeadude@dude.com likeadude@likeIcare.com likeabrother@brother.com likeabrother@likeIcare.com myneighbour.freak@freaky.com myneighbour.likeIcare.com myniece.icecreamelolly@sweet.com myniece.icelikeIcare.com

<tbody>
</tbody>

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

Edit: Just noticed that Rick commented this.

Or select the column to process, go to Edit/Replace, and replace „@*.” with „@likeIcare.” (without quotes).

Or select the column to process, go to Edit/Replace, and replace „@*.” with „@likeIcare.” (without quotes).
@damian_lee,

Note that using István's suggestion will physically changes your original (existing) data.

Note that using István's suggestion will physically changes your original (existing) data.

Thanks, Rick. @ OP: copy the column to process in another column first if you wish to keep the original.

Replies
1
Views
399
Replies
3
Views
1K
Replies
4
Views
829
Replies
0
Views
569
Replies
9
Views
8K

1,203,610
Messages
6,056,291
Members
444,855
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back