Remove hyperlinks from excel

[newexcler]

Hi Experts,
I have stuff copied from site to do some analysis. The categories are in the font: Calibri Light (Heading) and others are Calibri Body and
Calibri Light header is hyperlink and I am not able to get rid off. I selected entire sheet and removed hyperlinks and now I do not even have "Remove Hyperlink option"
I do not want to change the excel settings to disable links. I just want text in this so that I can do some excel analysis.

I am bit puzzled, is there conditions and options to remove all hyperlinks from excel sheet.

Any help would be appreciated.

 

[Alex Blakenburg]

Glad that we were able to help. Sorry we couldn't resolve the hyperlink issue without having access to your file. Thank you for letting us know that you were able to use Power Query to clean up your data.