IT Operations Manager

Isaias Perez

<div>
<div class="content wysiwyg-content">
I have a column that is full of user IDs and i need to add @contoso.com to the end of each of these user IDs. What excel function can i use to make this happen? So I column named SamAccountName with user IDs that are for example 9991111 and 9991112. The coloumn has 100s of user ids and i want to add @contoso.com to the end of all those IDs. Some are numbers and others are alphabetical like &quot;JDoe&quot;. Its a CSV File.
</div>
</div>


I have a column that is full of user IDs and i need to add @contoso.com to the end of each of these user IDs. What excel function can i use to make this happen? So I column named SamAccountName with user IDs that are for example 9991111 and 9991112. The coloumn has 100s of user ids and i want to add @contoso.com to the end of all those IDs. Some are numbers and others are alphabetical like "JDoe". Its a CSV File.

Excel- Add domain to end of Sam Account name Coloumn

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.