I've already used a formula then pasted just the values to remove all hyphens from the phone numbers, as previously stated, all the cells show the correct data in 1234567890 format.... it just doesn't merge correctly.