# How to combine text with a percentage in Excel

Format the number inside the formula with TEXT: `=A2&" margin: "&TEXT(B2,"0.0%")`.

**Excel:** `=A2&" margin: "&TEXT(B2,"0.0%")` (Excel 2019 and later, including Microsoft 365)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C |
| --- | --- | --- |
| Product | Margin | Label |
| Lamp | 0.4624 |  |
| Chair | 0.3494 |  |
| Desk | 0.3296 |  |
| Monitor | 0.3773 |  |

Formula in C2, filled to C5: `=A2&" margin: "&TEXT(B2,"0.0%")`

Result: Lamp margin: 46.2%; Chair margin: 34.9%; Desk margin: 33.0%; Monitor margin: 37.7%

## How it works

A cell's Percent format only changes how it looks; the value is still 0.4624. Joining it to text with `&` uses the value, so you get "Lamp margin: 0.4624". TEXT turns the number into text in the format you give it, "0.0%", before it is joined.

## Other ways

- `=CONCAT(A2," margin: ",TEXT(B2,"0.0%"))`: The same label with CONCAT instead of &.
- `=A2&" margin: "&B2`: The version that goes wrong. (Shows the raw decimal: "Lamp margin: 0.4624".)

## Common mistakes

- The format code is in quotes: `TEXT(B2,"0%")` for whole percents, `"0.00%"` for two decimals.
- The result is text, so it can't be added up or charted. Keep the number in its own cell and use the label only for display.

## Questions

**How do I show a percentage with a plus sign?**

Give TEXT a positive and a negative section: `TEXT(B2,"+0.0%;-0.0%")`.

**Do format codes differ by language?**

Yes. Some non-English versions of Excel use other codes for decimals and dates in TEXT; "0.0%" works in English versions and in Google Sheets.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/combine-text-with-a-percentage