As the sheet shows it
5½
A fraction glyph and a stray tag. The column is mapped to uk_size.
Preview, beside the original
5.5
Markup stripped. The fraction glyph becomes a decimal. Nothing is reworded.
Preview, beside the original
5.5
Keeps the first number, decimal point included. The tag is dropped.
Preview, beside the original
(blank)
Letters only. A cell that is just a size comes back empty, and the field is left blank.
| Field | Original cell | Written value |
|---|---|---|
| uk_size | 5½ | 5.5 |
Nearest value we use. An exact match is kept. Anything with no neighbour is blanked rather than invented.
| Row | Supplier cell | On the list | Will write | |
|---|---|---|---|---|
| 42 | Extra wide | no | 4E | nearest |
| 43 | EEE | yes | EEE | kept |
| 44 | super-narrow | no | (blank) | no neighbour |
Row 42 now holds 4E. Row 44 is blank. Row 43 was already on the list. The original cells stay in the change report.
| As staged | Rows | Settles on | Why | |
|---|---|---|---|---|
| NORTHMILL | 42 | Northmill | Shop list | would change |
| PEBBLE LANE | 18 | Pebble Lane | Shop list | would change |
| harbour thread | 7 | Harbour Thread | Shop list | would change |
| Calder & Pine | 11 | Calder & Pine | Already the shop spelling | matches |
0 rows left The label capitals and the lower-case feed now use the shop spelling. Filters see one brand, not two.