How to Fix Microsoft Lists Calculated Column LEFT and CONCATENATE Errors
Question details
Users encounter execution or syntax errors when using the LEFT and CONCATENATE functions in Microsoft Lists calculated columns, despite simpler formulas functioning properly.

- Product
- Microsoft Lists
- Device & OS
- not provided
- Scenario
- Creating or editing a calculated column in Microsoft Lists using specific text manipulation functions with multiple parameters.
- Observed behavior
- The calculated column returns an error message instead of the expected processed text string, making it difficult to extract characters or combine text data.
Ensure you have the appropriate site permissions to edit list settings and manage columns within the affected Microsoft List. Verify that your column names are correctly spelled and enclosed in square brackets.
Isolate the Issue via Standard Troubleshooting
Determine whether the calculated column error is caused by a localized browser issue, a corrupted specific list, or a tenant-wide problem.
Often, backend glitches or browser caching issues can cause Microsoft Lists to misinterpret complex formulas. Isolating the environment helps identify the root cause.
Log into your Microsoft 365 account using a different web browser (e.g., Edge, Chrome, or Firefox) or an Incognito/Private window to rule out cache or extension interference.
Create a brand-new list in your SharePoint site. Add basic text columns and try creating a new calculated column using the exact same LEFT or CONCATENATE formula to see if the issue is restricted to the original list.
Ask a colleague with sufficient list permissions to test the same calculated column formulas on their account to determine if the error is user-specific or tenant-wide.
Verify Formula Syntax and Regional Delimiters
Check your SharePoint regional settings to ensure you are using the correct delimiter (comma vs. semicolon) in your formulas.
Manage Data and Formulas Offline with WPS Office
If you are frustrated with browser-based limitations or complex syntax errors in online list management, WPS Spreadsheet offers a powerful, desktop-level alternative. Easily organize data, run complex text formulas, and analyze information without the hassle of online sync issues.
- 1. Export your Microsoft List: Click 'Export' in your Microsoft List and choose 'Export to Excel' or 'Export to CSV'.
- 2. Open with WPS Spreadsheet: Launch WPS Office and open the downloaded spreadsheet file to view your data.
- 3. Apply complex formulas freely: Use standard Excel-compatible syntax for LEFT, CONCATENATE, and other functions without worrying about online browser restrictions.

Frequently Asked Questions
Why does my CONCATENATE formula return a syntax error in Microsoft Lists?
Syntax errors in CONCATENATE usually occur if you are missing square brackets around column names (e.g., [Column Name]), forgetting quotation marks around static text strings, or using the wrong parameter delimiter (comma vs. semicolon) based on your site's regional settings.
Can I use the ampersand (&) instead of the CONCATENATE function?
Yes, in Microsoft Lists and SharePoint calculated columns, you can use the ampersand (&) operator to join text. For example, using '=[First Name] & " " & [Last Name]' is often simpler and less prone to syntax errors than using the CONCATENATE function.
How do regional settings affect the LEFT function in calculated columns?
The delimiter used to separate arguments in functions like LEFT depends directly on your SharePoint site's regional settings. If your region uses a comma for decimals, you are required to use a semicolon to separate the text and the number of characters (e.g., LEFT([Text]; 5)).




