Document Editing Problems

How to Concatenate Word Table Cells with Text in Word 2021

Aamir Naveed Akram Sep 29, 2026 870 views

Question details

The user wants to combine text and values from multiple table cells in Word 2021, such as adding the word "Week" and a hyphen between two cell values.

How to Concatenate Word Table Cells with Text in Word 2021

Product: Word 2021
Device & OS: not provided
Scenario: Attempting to merge or concatenate table cell data with static text directly within a Word document table.
Observed behavior: Standard Excel formulas like CONCAT produce syntax errors because Word table formulas operate differently and do not fully support text string manipulation.

Before you start

Before proceeding, ensure the Developer tab is enabled in your Word ribbon, as using a VBA macro is the most reliable method for complex text concatenation in Word tables.

Solution 1Recommended

Use a VBA Macro to Concatenate Table Cells

Since native Word formulas lack robust text processing features, a VBA macro provides the flexibility needed to read, clean, and combine cell text.

Word table cells contain hidden end-of-cell markers that must be stripped out before the text can be cleanly combined. A macro automates this process to prevent formatting errors.

Open the VBA Editor

Press Alt + F11 on your keyboard to launch the Microsoft Visual Basic for Applications (VBA) editor.

Insert a New Module

In the top menu, click on 'Insert' and select 'Module' to create a blank script window.

Write the Macro Code

Write a script that targets your specific table. You will need to extract the text from the desired cells (e.g., A3 and B3), use the Left function (Left(text, Len(text) - 2)) to remove the 2-character end-of-cell marker, and then define the output string.

Execute the Macro

Close the VBA editor, return to your Word document, and run your newly created macro from the Developer tab to populate the destination cell with the concatenated text.

Use a VBA Macro to Concatenate Table Cells

Solution 2

Apply a Basic Formula in Word Tables

For very simple combinations or numeric sequences, you can attempt to use the built-in Word Formula dialog, though text handling is strictly limited.

Efficient Data Processing

Seamlessly Process and Combine Table Data with WPS Office

While word processors struggle with complex table formulas, WPS Office allows you to effortlessly combine text and table data using WPS Spreadsheet, and then flawlessly paste the formatted table into WPS Writer.

1. Process Data in WPS Spreadsheet: Open WPS Spreadsheet and input your table data into the cells.
2. Use Native Formulas: Use standard formulas like ="Week " & A3 & " - " & B3 to effortlessly concatenate the text.
3. Copy the Results: Highlight the processed table cells and press Ctrl+C to copy them.
4. Paste into WPS Writer: Open your document in WPS Writer and press Ctrl+V to paste the cells directly. The table structure and text will be preserved perfectly.

100% compatible with Microsoft Word and Excel file formats (.docx, .xlsx).Fully supports advanced Excel-style formulas like CONCAT and text operators.Lightweight, fast, and completely free to use.Seamlessly copy and paste data between Spreadsheets and Writer without losing formatting.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the CONCAT function give a syntax error in Word tables?

Word table formulas are designed primarily for basic mathematical calculations (like SUM or AVERAGE) and do not support the extensive list of text-processing functions found in Excel, such as CONCAT or TEXTJOIN.

Can I link an Excel spreadsheet to my Word document to solve this?

Yes. You can embed an Excel worksheet inside Word by going to Insert > Table > Excel Spreadsheet. This gives you access to all native Excel formulas, including text concatenation, directly within the Word interface.

How do I remove the end-of-cell marker when using VBA in Word?

In VBA, every Word table cell string ends with a special two-character marker (a carriage return and a bell character). You can remove it by using the Left function: CleanText = Left(CellText, Len(CellText) - 2).

Document & File Issues