Inserting text into a cell containing text

**KRayKeeling** · 06-10-2009, 09:45 AM

I have pulled a report from a website. The website only allows a certain number of characters. For instance it might go to john.smith@, dave.bird@, tom.jones@... this has been pulled into an excel sheet. I want to add the domain at the end of the email address so it would become

john.smith@whatever.com
dave.bird@whatever.com
tom.jones@whatever.com

But I have a list of 2000 usernames and I don't want to go line by line inserting whatever.com.

Is there a way to automatically do this?

Thank you

**NBVC** · 06-10-2009, 09:50 AM

If it always the same "whatever.com" then you can use Edit|Replace

and Replace @ with @whatever.com

**researcy** · 06-10-2009, 09:54 AM

I'd use CONCATENATE. In col A you'd have john.smith@, In col B, put whatever.com, then in col C enter this formula:

=CONCATENATE(A1,B1)

Paste down col C and you should have them all.

If you copy it to another sheet use the Paste Special to remove the formula.

**Excel Matic** · 06-10-2009, 10:07 AM

concatenate would work better - as by using replace, you will stand chances of replacing un-wanted text

**KRayKeeling** · 06-10-2009, 10:46 AM

Thanks so much for all of your help! That was awesome!

**NBVC** · 06-10-2009, 10:55 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save