Question:-How to Turn Multiple Hyperlinks into Text in Microsoft Office Excel?
Answer:-Turn Multiple Hyperlinks into Text in Microsoft Office Excel
1. Select the cell or group of cells that contain hyperlinks, right-click, and then click Copy.
2. Select the cells where you want your text to go (this might be the same selection as in step 1).
3. Right-click, and then click Paste Special.
4. Click the options you want to use (such as Values or Comments), and then click OK.