When you enter a special symbol for many times in your
sheets, it is time-consuming to enter the symbols even through copying
and pasting. This section describes how to enter special symbols by
finding and replacing.
Microsoft® Excel
2003
To enter a special symbol, do the following steps:
- Enter a character or an expression to substitute the symbol during
your typing.
Note: This character or expression must not
be used anywhere else in this sheet.
- Click to open the Find and Replace window.
- Enter the character or expression in the Find what field,
and the symbol in the Replace with field.
- Click Replace All.
IBM® Lotus® Symphony™ Spreadsheets
To
enter a special symbol, do the following steps:
- Enter a character or an expression to substitute the symbol during
your typing.
Note: This character or expression must not
be used anywhere else in this sheet.
- Click to open the Find and Replace
window.
- Enter the character or expression in the Search for field,
and the symbol in the Replace with field.
- Click Replace All.