Adding text string to cells
 

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 " to the right of each
userid in the column. Can someone tell me how to do this in excel or access?

Adding text string to cells
 

Hi Ray
Try this: ", replace a1 with proper cell reference.

"Ray W." <Ray wrote in message
...
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 " to the right of each
userid in the column. Can someone tell me how to do this in excel or
access?

Adding text string to cells
 

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

"Ray W." wrote:

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 " to the right of each
userid in the column. Can someone tell me how to do this in excel or access?