Excel- Add domain to end of Sam Account name Coloumn

Isaias Perez
Isaias Perez used Ask the Experts™
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.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Analyst Assistant
You could use a simple formula like this, which assumes the IDs are in column A starting in row 2.

=A2& "@contoso.com"
Isaias PerezIT Operations Manager


Thank you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial