Decode plus-sign spaces in form text
Turn + and %20 into spaces, then %2B back into a plus sign.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | SUBSTITUTE(A8,"+"," ") | Turns each + sign into a space. | "Ava Reed %2B Noah…" |
| 2 | SUBSTITUTE( … "%20" … ) | Turns each %20 into a space. | "Ava Reed %2B Noah…" |
| 3 | SUBSTITUTE( … "%2B" … ) | Turns each %2B back into a + sign. | "Ava Reed + Noah Park" |
| 4 | SUBSTITUTE( … "%2b" … ) | Does the same for a lowercase %2b. | "Ava Reed + Noah Park" |
Each bracket wraps the one above it, so Excel works from the inside out. + goes first, so a decoded %2B stays a plus.
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A8,"+"," "),"%20"," "),"%2B","+"),"%2b","+")How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own fields. Paste one field per row into the green column of the Template tab. The decoded text fills in by itself.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use this only on form text where a + stands for a space. Other codes, like %40, stay as they are.
Microsoft's help: SUBSTITUTE function
OTHER ROUTES YOU MIGHT LIKE

Unwrap a CSV field with doubled quotes
"Ava ""Avie"" Reed" → Ava "Avie" Reed
Get the template →
Remove a CDATA wrapper, keep &
<![CDATA[Ava & Noah Reed]]> → Ava & Noah Reed
Get the template →
Turn codes like < back into symbols
Ava "Avie" Reed → Ava "Avie" Reed
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →