Adding text string to cells

[Ray W.]

I have a spreadsheet of Active Directory user information. One column
includes the userid for exchange email and not the exchange serverid i.e.,
@myplace.com. I'm not sure if excel can do this for me or if it would be
easier in Access. I need to add the "@myplace.com" to the right of each
userid in the column. Can someone tell me how to do this in excel or access?

 

[Cimjet]

Hi Ray
Try this: =a1&"@myplace.com", replace a1 with proper cell reference.

 

[Rayashe]

You could also format the cells to Custom and input @"@myplace.com" as the
format code, then no matter what you type in that cell it will have
@myplace.com added.