Formulas in SharePoint Lists: LEFT & RIGHT

This tutorial will show you how to create a calculated column in a SharePoint Online list that uses the LEFT and RIGHT formula to extract data from another column. Specifically, this tutorial will show you how to create a column in SharePoint List that extracts data from a string column, integer column, and a data-time column. Using the LEFT and RIGHT formulas in a SharePoint list is exactly the same as using the formulas in Microsoft Excel.

For reference the formulas are:
LEFT(text,num_chars)
RIGHT(text,num_chars)

Reference Links:
https://support.microsoft.com/en-us/office/left-function-913824b4-fc42-4c8c-9229-0eaa57dcdf49
https://support.microsoft.com/en-us/office/right-function-112699e2-fe7e-4cbf-8d1e-0e8db3884f26

Timeline:
0:00 – Start
0:20 – LEFT & RIGHT Formula in Microsoft Excel
0:50 – How to create a calculated column in SharePoint List
1:30 – Using the LEFT Formula on a string column in a SharePoint List
3:00 – How to select calculated column data type in SharePoint List
4:20 – Using the LEFT Formula on an integer column in a SharePoint List
6:20 – Using the LEFT Formula on a date column in a SharePoint List
7:20 – Using the RIGHT Formula on a string column in a SharePoint List
8:40 – Limitations of LEFT & RIGHT Formulas in a SharePoint List

🚩 Connect with me on social:
Twitter: https://twitter.com/LuigiIacobellis
Instagram: https://www.instagram.com/luigiiacobellis/
LinkedIn: https://www.linkedin.com/in/liacobe/

Submit feedback on my content here: https://bit.ly/3yjEewm

For business inquiries, contact me at [email protected]

🔔 Subscribe to my YouTube channel:
https://www.youtube.com/channel/UCIT-_HqO9Z_KHY8bk8jHVJA?sub_confirmation=1

This video was created using Camtasia 2020. You can download your free trial at the following links:

Camtasia US: http://bit.ly/3eRT9a7
Camtasia Germany: http://bit.ly/3eTZVw2
Camtasia France: http://bit.ly/3tsIsP2
Camtasia Spain: http://bit.ly/3rYWCHn

Screenshots included in this video were created using Snagit 2020. You can download your free trial at the following link: http://bit.ly/30RJ3h6

The audio in this video was recorded using a Blue Yeti Nano. You can purchase yours at the following links:

Amazon US: https://amzn.to/30UENgN
Amazon Canada: https://amzn.to/3sxq7Ar
Amazon United Kingdom: https://amzn.to/2NyrY90
Amazon Germany: https://amzn.to/3tRHDQe

Get a Subscription to Microsoft 365 & Get Access to Microsoft Teams for Your Friends & Family: https://bit.ly/3t86RdH​

Note that I may earn a small commission at no additional cost to you from purchases made using these links.

#Sharepoint #SharePointOnline #Microsoft365