Hello Qiyao, If that happened in A1,put a formula into B1: =A1 Then copy and Menu:Edit>"PasteSpecial..." with option"Text" but without "Formulas". You can do the same with many cells at once. Pasting the text-values won't generate hyperlinks.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
