Others

How to Fix Microsoft Lists Calculated Column LEFT and CONCATENATE Errors

Emma BrownEmma Brown Nov 2, 2026 868 views

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.

How to Fix Microsoft Lists Calculated Column Errors for LEFT and CONCATENATE Functions
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.
Before you start

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.

Solution 1Recommended

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.

1
Test a different web browser

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.

2
Create a new test list

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.

3
Verify with other users

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.

Tenant-Wide Issues: If the issue persists across different lists, browsers, and user accounts, it may be a temporary Microsoft 365 backend bug requiring a support ticket.
Free Microsoft Office alternative

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. 1. Export your Microsoft List: Click 'Export' in your Microsoft List and choose 'Export to Excel' or 'Export to CSV'.
  2. 2. Open with WPS Spreadsheet: Launch WPS Office and open the downloaded spreadsheet file to view your data.
  3. 3. Apply complex formulas freely: Use standard Excel-compatible syntax for LEFT, CONCATENATE, and other functions without worrying about online browser restrictions.
Seamlessly compatible with Microsoft Excel (.xlsx, .xls) files exported from Microsoft Lists.Supports all standard text formulas natively, including LEFT, RIGHT, and CONCATENATE.Completely free, lightweight, and works perfectly offline.Familiar user interface requires no learning curve for Microsoft Office users.
microsoft office alternative - wps office

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)).