Conservative on purpose
Only values that are clearly a single phone number, made of digits and common punctuation with 7 to 15 digits, are reformatted. Values with extensions, words or several numbers, like “555-0102 ext. 4” or “call after 5pm”, are left exactly as they are, so digits are never merged by accident.
Adding a country code
Many tools want E.164 numbers such as +447700900123. If your numbers are all from one country and start with a trunk 0, use Find & replace on the phone column with Regular expression on: find ^0 and replace it with +44 (for the UK) or your own country code.
Keeping numbers intact in Excel
Excel drops leading zeros and the + sign when it opens a CSV file. When you download as .xlsx, values like 07700900123 are stored as text so they stay intact. If you open a CSV in Excel instead, import it with Data > From Text/CSV and set the column type to Text.