| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format cells based on text string contains | Excel Worksheet Functions | |||
| Adding Text to a String | Excel Discussion (Misc queries) | |||
| concatenate a text string if two different cells contain the sam. | Excel Worksheet Functions | |||
| Need to convert text string to seperate cells | Excel Worksheet Functions | |||
| Cells and and spaces after a string of text | Excel Worksheet Functions | |||
Linear Mode
