OmniDocCombine and Append Text With Excel Formulas
Learn how to join text from several Excel cells with separators using the ampersand, CONCAT and TEXTJOIN, plus fixes for spacing, dates and blanks.
Building a full name from a first name column and a last name column, or joining a product code to its size, is a task most spreadsheet users run into sooner or later. Excel has no separate "append" command for this. You build the combined text with a formula, and the formula stays linked to the source cells until you decide otherwise. This guide covers the excel formula append text approach, along with the related excel formula append string method, so you can join cells, add separators and fix the common problems that show up in the output.
The steps below use a simple layout: names in columns A and B, with the combined result in column C. The same logic works for addresses, codes, labels or any other text. You do not need to know advanced functions to follow along, although a couple of newer functions need a recent version of Excel, which is covered in the checklist.
How do I append text in Excel with a formula? The short answer
Use the ampersand (&) to join cells and fixed text in one formula. For longer lists, use TEXTJOIN, which takes a separator once and joins an entire range.
| Your situation | What to do | Why |
|---|---|---|
| Joining two or three cells with a space or comma | =A2&" "&B2 | Works in every version of Excel and shows each piece clearly. |
| Joining several cells in a row or column | =TEXTJOIN(", ",TRUE,A2:A10) | Applies one separator to the whole range and can skip blanks. |
| Adding words around a number | ="Total: "&TEXT(B2,"0.00") | TEXT controls how the number looks, so decimals stay consistent. |
| Starting a new line inside one cell | =A2&CHAR(10)&B2 | CHAR(10) inserts a line break, which shows only when wrap text is on. |
| Joining cells with CONCAT | =CONCAT(A2," ",B2) | Does the same job as & in newer versions, but has no separator argument. |
Before you start
Check these points first. Each one prevents a problem that is hard to spot once you have filled a formula down hundreds of rows.
- Your Excel version. TEXTJOIN and CONCAT are available in Excel 2019, Excel 2021 and the current subscription edition of Excel. The ampersand works in all versions, so use it if you are not sure what you have.
- Stray spaces. Extra spaces at the start or end of a cell appear in the result as gaps. You can wrap a cell in TRIM, such as =TRIM(A2), to remove them before joining.
- Numbers and dates. A date stored as a number will join as a number, not as the date you see on screen. Format these with TEXT before joining.
- Blank cells. If a cell in the middle of a range is empty, a plain join leaves a double separator. Decide whether you want blanks skipped.
- A place for the output. Use an empty column next to the source data. That way the original values stay in place while you check the results.
Using an Excel formula to append text, step by step
- Choose an empty output column. Pick a column that has no data, such as column C beside names in A and B. This keeps your source data untouched while you work.
- Start the formula. Click the first output cell, C2, and type an equals sign. Excel reads anything after the equals sign as a formula.
- Select the first cell and add a separator. Type A2, then &" "& to add a space between the two pieces. The quotation marks tell Excel to treat the space as literal text.
- Finish the join. Type B2 and press Enter. C2 now shows the first and last name together, with a space between them.
- Copy the formula down. Drag the fill handle at the lower right corner of C2 down to the last row of data. Excel adjusts the row references for each line.
- Switch to TEXTJOIN for longer ranges. If you need to combine many cells, type =TEXTJOIN(", ",TRUE,A2:A10). The first argument is the separator, and TRUE tells Excel to skip empty cells.
- Format numbers inside the formula. For a number in B2, type ="Total: "&TEXT(B2,"0.00") so the result always shows two decimal places. Change the format code to match your own needs.
- Paste the results as values if you need to move them. Copy the output column, then paste it as values on top of itself or in a new column. This removes the link to the source cells, so sorting or deleting rows will not change the text.
Check the result
Once the formulas are filled down, look through the output before you use it. The table below lists the usual issues and how to fix them.
| Check | How to see it | If it's wrong |
|---|---|---|
| Spacing and punctuation | Compare the first and last rows against the source cells. | Add the missing separator, or wrap the inputs in TRIM to remove extra spaces. |
| Numbers showing as codes | A date appears as a five-digit number like 45123. | Wrap the cell in TEXT with a date or number format. |
| Extra commas or spaces | Rows with blanks end in a double separator. | Switch to TEXTJOIN and set the second argument to TRUE. |
| Formula shows as text | The cell displays the formula itself, not the result. | Check that the cell is not formatted as Text, change the format, then re-enter the formula. |
| Line breaks not visible | The cell looks like one line. | Turn on wrap text for the cell. |
If the text you are joining is in another language, translate the source content first, then rebuild the formulas on the translated cells. Automatic translation can change wording, so read the final output carefully before you rely on it. OmniDoc can translate Excel (.xlsx) files on omnidoc.top, keeping the worksheet structure, but you should still check the joined text afterward.
❓ FAQ
1. Can I append text without creating a new column?
Yes, but it is safer to work in a new column first. Once the results look right, copy them and paste them as values over the original column. Keep a backup copy of the file in case you need to start over.
2. Does CONCAT replace the ampersand?
It can do the same job for simple joins, such as =CONCAT(A2,B2). The ampersand still works in every version of Excel, and CONCAT does not take a separator argument, so you must type the separator between each cell.
3. How do I keep leading zeros when joining codes?
If a code such as 00123 is stored as a number, Excel drops the zeros. Use TEXT with a fixed-length format, such as =TEXT(A2,"00000"), so the code keeps all five digits when joined to other text.
4. What is the difference between TEXTJOIN and CONCAT?
TEXTJOIN takes a separator once, then a TRUE or FALSE setting for empty cells, then the range. CONCAT just joins the items you list. Use TEXTJOIN when you join a whole column or row with one separator.
📝 Summary
For an excel formula append text task, the ampersand handles simple joins and TEXTJOIN handles ranges with one separator. Check spacing, number formats and blank cells before you rely on the output. Once the results are correct, paste them as values if you plan to sort or move the data.
