albatross. 1  A metaphor for a dead weight or burden that one must carry, especially when the burden is not a literal one but a stigma of some kind that one cannot easily discard or throw off. The name comes from a story about a sailor who killed an albatross that was following his ship, an act thought to bring bad luck upon the ship.
Run the Remove Characters tool by clicking on its icon under the Ablebits Data tab in Excel. To remove characters select the range with the cells that contain values you want to delete. Expand the group Remove characters or substrings. You can select one of three radio buttons according to your task.
1 Select the cells with hyperlinks that you want to delete. 2  On the Home tab, in the Clipboard group, click the down arrow and then click on Paste Special. 3  Under Operation, click on Multiply, and then click OK. 4  On the Home tab, in the Styles group, click on Cell Styles. 5  From the drop down menu, click on Normal.elect all cells you want to clear from hyperlinks, right click and Cut or use. +. . Now open up a notepad window and paste it there. Now select all the lines with content from notepad and right click Cut or use. +. . Now select the top cell of the just cut column in Excel and right click Paste or use. +. .