Adding text string to field

[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 access or excel?

 

[ND Pard]

Assume:
cell A2 contains: pkramer
cell B2 contains: @myplace.com
in cell C2 enter the formula: +A2&B2 and press Enter or
in cell C2 enter the formula: +A2&"@myplace.com" and press Enter

Cell C2 will now display: (e-mail address removed)

Copy cell C2 down as many cells as needed.

Then Hi-Lite all of the cells you've placed this formula into in column C.
Right-Click and Copy.
Right-Click and PasteSpecial, check "value" and click "OK",
this will convert all the formulas to values.

Hopefull this will work for your needs.

Good Luck.

 

[Klatuu]

To do it in Access, you would use an update query to change the value of the
file to add the additional string.