Changing Unique Text within Cell

[digitap]

Hi All,

First posting so take it easy on me

I would like to change 100 cells within my spreadsheet with a formula. So the below will change from anthony@test.com to info@test.com

So all these;

test@test.com
me@test.com
blah@future.com
excel@excel.com

I want to take the characters before the @ sign and changed them all to:

info@test.com
info@test.com
info@future.com
info@excel.com

Any help would be much appreciated.

Thanks
Anthony

 

[digitap]

Ok ive just done that but getting no change. When i hit enter a blue box goes around A1 but the formula just stays there. Maybe im missing something from the formula ? Im putting in exactly like this into B1.............. =REPLACE(A1,1,FIND("@",A1),"info@")

 

[vds1]

Check if show formulas is highlighted under formulas tab ? If so, un-highlight it.

 

[digitap]

Ok, it looks like its being recognised as info@ (i can see this in the format tab) but to me in the actual cell its not changing. So any ideas ?

 

[Scott Huish]

Make sure the cells are not formatted as text, but General.
or
Hit CTRL-`

Excel Workbook
	A	B
1	test@test.com	info@test.com
2	me@test.com	info@test.com
3	blah@future.com	info@future.com
4	excel@excel.com	info@excel.com
Sheet1

 

[digitap]

Ok, i just opened a different spreadsheet with data and its worked.

Thanks sooooooo much for all your help everyone. Very quick and prompt.

thank you.