How to Concatenate Columns in Calculated Column in Microsoft Lists - How to use Microsoft Lists

How to Create a Calculated Column - • How to Create a CALCUL...
In this video, I am going to show you two ways to concatenate or combine columns in Microsoft Sharepoint Lists. We will learn how to create a calculated column in Lists. The two ways are the =CONCATENATE() formula and ampersand (&). We will start with the basic functions and then build on them so that you can use them effectively. We will also learn my 'burger' trick for remembering the ampersand formula. At the end, I have a ** BONUS ** tutorial where we will learn how to concatenate date columns as well as different date format options.
If you are a student, teacher, project manager, business owner or super nerd like me, then we have got you covered!
OFFICE SKILLS WITH AMY
Welcome to Office Skills with Amy! We create easy-to-follow and engaging how-to-technology videos to help you boost your productivity and save time in the office.
DISCOVER YOUR INNER NERD
We believe that being a 'nerd' is a term of pride, I personally, have been advertising myself as an Excel Nerd in interviews since 2009.
Our goal is to inspire you to unleash the power of technology and Discover Your Inner Nerd along the way. We're here to show you how to make the most out of Microsoft 365 apps and other cutting-edge technology
WHAT WILL YOU LEARN
Whether you're a beginner or an experienced user, we'll help you become more efficient, automate tasks, and save time.
NEW CONTENT WEEKLY
With new content every week, we'll keep you up-to-date on the latest technology trends and help you stay ahead of the curve.
TECHNOLOGY VIDEOS TO COME
Microsoft 365 apps including Microsoft Office, Microsoft Loop, Microsoft Teams, Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Microsoft Outlook, Microsoft OneNote and more!
LIKE, COMMENT & SUBSCRIBE
Don't forget to like, comment, and subscribe to our channel to show your support and stay tuned for more technology videos to come. Let's Nerd Out together and unleash the power of technology!

[@Naveenkumar-pp3iu]

Thanks Amy, for the video. It was lucid and simple. Greetings from India 😊✌

[@officeskillswithamy]

Thank you for the comment! I'm happy that it helped!

[@tewwonwonii8462]

Excellent.

[@officeskillswithamy]

Many thanks!

[@user-rr3ev5dm1z]

thank you very much

[@officeskillswithamy]

Glad it helped

[@alanparker3624]

Hi, I'm new to your channel. I have just looked around the channel, very nice and professional. I will definitely be looking at your previous videos asap. Do you have any plans to cover Microsoft copilot?

[@officeskillswithamy]

Welcome aboard! Thank you :) Yes, I do plan to do some videos on Copilot in the future.

[@bencale3384]

Great video, Do you know if there is any way to add a carriage return to have the separate values on a new line?

[@officeskillswithamy]

This is not possible unfortunately, calculated columns only work within their row. Depending on your circumstance, if you are wanting a sequential number in your concatenated column you could use the ID # column as this will pull #1, 2, 3 and so on.

[@bencale3384]

Thanks for your prompt reply. For clarity I am trying to join 3 text columns from the same row to have their own line in the same "cell". I tried adding but that no longer works, then char(13) like you can in excel, I even tried changing the JSON but couldn't get any to work 😢 As you said, I don't think it's currently possible.

[@officeskillswithamy]

I see, thank you for the clarification. Yes, unfortunately, it can only work on one line.

[@marianosentupery5986]

Hi Amy, thanks for sharing this content. I'd like to ask if you know how to concatenate 2 column but one if them is a calculated column and that column does not appear in the box column to be added in the formula. Hope to be clear with my question. Best regards,

[@officeskillswithamy]

Hello! Thank you for asking. What type of output is the calculated column that is not showing up? There may be a limitation.

[@parmmair6951]

Great video 👍Is there away to do more than 30 items.

[@parmmair6951]

Found a way, did two separate ones with 30 in one and 20 items in another and combined the 2 items.

[@officeskillswithamy]

Thank you for the comments and for the update :) That was going to be my suggestion so I am pleased to hear that you were able to make it work! I would also say that doing separate mini concatenates would make it easier to navigate the formula area and eliminate errors. You can simply hide those working columns as well.