HOW TO COMBINE DATA FROM MULTIPLE CELLS INTO ONE CELL IN EXCEL (USE OF AMPERSAND IN EXCEL) // Did you know you can use the ampersand (&) calculation operator to join text items instead of using the Concatenate function? In many cases, it is simpler to use the ampersand. This video demonstrates how to create a new Position ID Number by stringing a few relevant columns of data together.

Here is how the "&" operator works:
=A2&B2&C2 (This will give you a result of combining the text in cells A2, B2 and C2 without spaces). This would be the same result if you used the Concatenate function =Concatenate(A2,B2,C2)
__________
FREE DOWNLOADS:
Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
CONNECT WITH ME:
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.

LinkedIn: https://www.linkedin.com/in/sharonsmithhr

Twitter: https://twitter.com/SharonSmithHR
__________
RESOURCES:
I use clip art and templates from PresenterMedia and I highly recommend them. They have an amazing selection and excellent terms. Here is an affiliate link: https://shareasale.com/r.cfm?b=417324&u=2065055&m=43706&urllink=&afftrack=
__________
NOTE: Some links included here are affiliate links. If you click on these links and make a purchase, we may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
KEYWORDS: #MSExcel, microsoft excel tutorial, Concatenate, Concat, combine data from multiple cells into one cell excel, using & to string data together, Sharon Smith HR, @SharonSmithHR
__________
PLAYLISTS:
Excel Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90

Excel Quickies (Around 2 Minutes): https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW

Word Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45

PowerPoint Tutorials for HR: https://www.youtube.com/watch?v=XBl4hDLjtiI&list=PLb80efKTbWuMcFRbsZO5wkXgYjBG4meRM

For HR Professionals: https://www.youtube.com/watch?v=5FxsWiqtXR4&list=PLb80efKTbWuNk9PyISH2lxRI0JBekYANI

For Job Seekers: https://www.youtube.com/watch?v=PVjc-NUn0mo&list=PLb80efKTbWuNB9ex-F50NRgt_V26U9UPx

Welcome | About Me: https://www.youtube.com/playlist?list=PLb80efKTbWuOd17uW4U2V8Xip0sTAfkLR