Let's say in cell A1, you've input the term "LinkABC", which contains a hyperlink to somewhere else in the workbook. You want to set cell B1 equal to A1. If you enter =A1 into the formula bar in cell B1, it will copy the text only, without the hyperlink.
Any simple solution? (I know you can just copy/paste, but that won't work for my purposes -- I'm looking for what'd you'd enter into the formula bar in cell B1)
Any simple solution? (I know you can just copy/paste, but that won't work for my purposes -- I'm looking for what'd you'd enter into the formula bar in cell B1)