GLM 5.2 vs Qwen3.7 Maxfor spreadsheets & Excel

Here is a single Excel formula that will normalise the postcode in cell A2 to the standard UK format:

`=UPPER(REPLACE(SUBSTITUTE(A2," ",""),LEN(SUBSTITUTE(A2," ",""))-2,0," "))`

**How it works:**
1. `SUBSTITUTE(A2," ","")` removes all existing spaces from the postcode.
2. `LEN(...)-2` calculates the position of the 4th character from the end (which is where the space should be inserted).
3. `REPLACE(..., ..., 0, " ")` inserts a single space at that exact position without deleting any characters (because `num_chars` is set to `0`).
4. `UPPER(.…

## The Formula

```excel
=LET(c, UPPER(SUBSTITUTE(A2," ","")), LEFT(c, LEN(c)-3) & " " & RIGHT(c, 3))
```

## How it works

The formula does three things in sequence:

| Step | Action | Example (`' m1 4wb'`) |
|---|---|---|
| **1. Clean** | `UPPER(SUBSTITUTE(A2," ",""))` — strips *all* spaces and uppercases | `M14WB` |
| **2. Outward** | `LEFT(c, LEN(c)-3)` — grabs everything except the last 3 chars | `M1` |
| **3. Inward** | `RIGHT(c, 3)` — grabs the last 3 chars | `4WB` |

These are then joined with a single space: **`M1 4WB`**

## Verificati…