Forum Discussion

DAP Amstel Vecht en Venen

Copper Contributor

Mar 05, 2018

deleting hyphens

I would like to remove the hyphens in a series of telephone numbers, any suggestions? Thanks, Hiltje

Diamond Contributor

Mar 05, 2018

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.