Adding text string to field

  • Thread starter Thread starter Ray W.
  • Start date Start date
R

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?
 
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.
 
To do it in Access, you would use an update query to change the value of the
file to add the additional string.
 
Back
Top