Concatenate cells
I have a spreadsheet with 3000 user names from AD. I need to take the username and append @domain.com. Example
EXcelhell.png
I desperately need help making [email protected] then output the result to A1. I would also like to be able to drag the + down to do all 3000 the same way.
Thanks in advance you guys and gals are great!!
Josh
1) In A1 put this formula
=B1 & C1
2) Click on A1, then doubleclick the lower right corner of that cell to copy that formula down the A column
3) Highlight and Copy column A
4) Select Paste Special > Values and the formulas in column A are removed leaving the results behind.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
wouldn't that just be =B1&C1?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks