Forum Discussion
hyperlink not showing correctly
I used a program to generate hyperlinks in Excel using =HYPERLINK("location", "text to show"). Strangely when opened in Excel, they all show as the full code of text instead of the "text to show" wit...
I found an indirect solution. I can copy the whole column and paste it to notepad. Save it as unicode text. Rename the extension to csv. Open it with Excel, and everything looks and links right. It's workable but requires extra steps.
BTW, the data contains non-West letters. I have to import from Data > From Text/CSV to show the text correctly. I don't know if it is related, but it worked without extra step in Excel 2010 which I don't have now.
Thanks!
BTW, the data contains non-West letters. I have to import from Data > From Text/CSV to show the text correctly. I don't know if it is related, but it worked without extra step in Excel 2010 which I don't have now.
Thanks!
- That happens every now and then if the workbook is generated from a non-Office app. Good workaround!
