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 cell A1. 2  On the Edit menu, click Replace. 3  Note In Microsoft Office Excel 2007, click Find & Select in the Editing group on the Home tab, and then click Replace. 4  In the Find what box, type 5  ~* . To do this, press TILDE, and then press ASTERISK.6  In the Replace with box, type 2. 7  Click Replace.xample 1: How to find and to replace numbers. 1  Type 494** in cell A1. 2  Select cell A1. 3  On the Edit menu, click Replace. 4  Note In Microsoft Office Excel 2007, click Find & Select in the Editing group on the Home tab, and then click Replace. 5  In the Find what box, type 6  ~* . To do this, press TILDE, and then press ASTERISK.