https://stackoverflow.com/a/41893584/5079799

Range.ClearHyperlinks ' Preserver Formatting
Range.Hyperlinks.Delete ' Removes Formatting