@ > Home > Contents > Search and replace characters like CR Excel 97+

Edit Search or Edit Replace does the desired operation in selected cells. Unlike in MS Word (with a preceding ^), the operation on some special characters is not documented.

There are two alternatives:

1. Printable but characters with special functions as * or ? can be treated by ~* or ~?.

2. All characters can by specified by "Alt-Key pressed + 4 numbers on numeric pad" (get familiar with their use/deactivation on notebooks or small keyboards) : Alt-0010 f.e. means CR (Carriage-Return).

At time of entry you might see happening nothing. Don't get irritated by that.

If you do not know a character's code, simply delete the preceding characters in A1, until =CODE(A1) shows the desired.

A list of all characters is given by filling down =CHAR(ROW(A1)).