First press the left arrow to select the complete row then by holding Ctrl Shift key together press Down Arrow to select the complete column. Click the cell that contains the formula. Num_chars - the number of characters you want to replace.
1 CTRL SHIFT END.
In the formula bar select the portion of the formula that you want to replace with its calculated value. Enter a formula into multiple cells with a single key stroke Ctrl Enter In situations when you need to input the same formula in more than one cell on a worksheet adjacent or non-adjacent ones this method can be a time-saver. First press the left arrow to select the complete row then by holding Ctrl Shift key together press Down Arrow to select the complete column. Switch to Replace tab and paste your range into Find what box.