deleting hyphens

Hi Hiltje,

 

General approach to transform phone numbers in different formats is here https://exceljet.net/formula/clean-and-reformat-telephone-numbers

 

Or you may simply select your range and replace (Ctrl+H) hyphens on nothing or something else.