Hi,
I have a spreadsheet with
1) links to other tabs - example: ='General Info'!$E$9
2) links to external documents - example: ='Sign in to your Microsoft account
Is there a way to remove the external links (item 2) while retaining the text or number? I tried to copy and paste number only; it worked if I manage to identify where the external links are located. If I copy and paste all, the links to the other tabs (item 1) will go missing too.
Thanks!
I have a spreadsheet with
1) links to other tabs - example: ='General Info'!$E$9
2) links to external documents - example: ='Sign in to your Microsoft account
Is there a way to remove the external links (item 2) while retaining the text or number? I tried to copy and paste number only; it worked if I manage to identify where the external links are located. If I copy and paste all, the links to the other tabs (item 1) will go missing too.
Thanks!