Data Cleaning Formula

I have messy data in Excel that needs cleaning:

**Column:** {{column}} (e.g., "Column B, rows 2-1000")
**Current format (messy):** {{messy_format}}
Example messy values:
- "{{example_1}}"
- "{{example_2}}"
- "{{example_3}}"

**Desired clean format:** {{clean_format}}
Expected output for the examples above:
- "{{clean_1}}"
- "{{clean_2}}"
- "{{clean_3}}"

Provide:
1. A formula I can put in an adjacent column to clean each row
2. If the formula is complex, break it into helper columns
3. If Power Query would be better for this scale, show that approach too

My Excel version: {{version}} (e.g., "Excel 365", "Excel 2019")