I have a list of names that I paste, individually, from a site into a column of cells in a table. I have conditional formatting to tell me if there are doubles. However, when I copy straight from the site (each name is actually a hyperlink), the conditional formatting goes away unless I tick the "keep destination formatting", but then the text doesn't have the hyperlink.
I'm aware that you can just keep destination formatting/type the name then add the hyperlink, but this added step takes much more time than simply copying and pasting the hyperlink. Is there a way to solve this problem?