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.
Re: Isolate and remove alpha characters and leave numeric. If you highlight the range you want to remove the kg from, you can perform a search and replace. In the find what: box, type kg (without the quotes) and leave the replace with: box blank.Then click on Replace all.e: Isolate and remove alpha characters and leave numeric. Well it does and it doesn't. That's a nice little tool (thanks) for eliminating the alpha, however, i wish to use it in conjuntion with a macro formula that will in turn perform a calculation on the new contents of the cell, say the 2.3.