Scenario (Applies to MS Excel)
When you type an entry in your worksheet that begins with any of the following prefixes, Microsoft Excel automatically creates a hyperlink:
• http:// • www. • ftp:// • mailto: • file:// • news: • \\
Excel also creates a hyperlink when you type an e-mail address in the following format: user name@company name.com
Task
Remove the hyperlinks of the data in a range in Excel. E.g. A1:A200
Approach
Use this VBA code to remove the hyperlinks:
Sub RemoveHyperlinks()
Range(“A1:A200”).Hyperlink
End Sub
