Adding text string to cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ray W. - 27 Mar 2008 14:26 GMT

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?

Reply to this Message

Cimjet - 27 Mar 2008 14:42 GMT

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

>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?

Reply to this Message

Rayashe - 28 Mar 2008 15:33 GMT

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.

> 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?

Reply to this Message

Rate this thread: