Excel replace *, special characters, formula and Highlight cells with formulas
There are usually two ways to express the multiplier sign, namely the asterisk * or the multiplier sign ×.
Chapters:
0:00 Excel replace * character with ×
0:32 Excel replace special characters
1:02 Excel replace formula
1:44 Highlight cells with formulas in Excel
Description:
Excel replace *, special characters, formula and Highlight cells with formulas
The asterisk * is usually used in formula calculations or VBA code, the multiplication sign × is generally used in the table to read, for example, to print out the table, usually use the multiplication sign ×; if the asterisk is used when making the table, you can replace them with the multiplication; because the asterisk * is a special character, it cann't be replaced directly, and an escape character needs to be added, the special character ~ and ? should be so. In addition to replacing words and symbols, you can also replace formulas, but the background color of cell can not be directly replaced, to change the background color of cell, especially batch modification, you need to use other methods.
One. Excel replace * character with × (Excel replace * character with blank, Excel how to replace * character)
Press Ctrl + H on the keyboard to open the "Find and Replace" window, and automatically select the "Replace" tab, enter ~* to the right of "Find what", enter × to the right of "Replace with", and click "Replace All", then all * in the table are replaced with ×.
Two. Excel replace special characters ~ (Excel replace special characters from cell)
1. Replace all ~ in a clothing table with empty. Press Ctrl + H on the keyboard to open the "Find and Replace" window, and automatically select the "Replace" tab, enter ~~ to the right of "Find what", and leave blank on the right of "Replace with".
2. Click "Replace All", a window that prompts several places have been replaced will be popped up, click "OK", then all special characters ~ will be replaced with blank.
3. If you want to replace the "question mark?", just change ~~ to ~?.
Three. Excel replace formula
1. Suppose we want to replace the average formula with the sum formula. Press Ctrl + ~ on the keyboard to switch to the Show Formulas state.
Note: Select the "Formulas" tab, click "Show Formulas" in the "Formula Auditing" group in the "Formulas" tab also switch to the Show Formulas state.
2. Press Ctrl + H on the keyboard to open the "Find and Replace" window, and copy the formula we want to replace into the input box on the right side of "Find what", for example, copy and paste =AVERAGE to there, and enter =SUM on the right side of "Replace with".
3. Click "Replace All", the formula in E2 is still the average formula, other formulas have been replaced.
4. Just click E2 or press Ctrl + S to save, and the average formula will become a sum formula.
Note: If you want to exit the Show Formulas state, just press Ctrl + ~ again, or click "Show Formulas" in the "Formula Auditing" group in the "Formulas" tab.
Four. Highlight cells with formulas in Excel
If we want to replace the background color, we can first use "Special" to find out the cell to be replaced, and then change the background color, the method is as follows:
1. If we replace the cells with formulas with orange. Press Ctrl + G on the keyboard to open the "Go To" window, click "Special", open the "Go To Special" window, select "Formula", click "OK", select all cells with formulas, click the "Fill Color" icon, select Orange in the pop-up panel, then the background of all selected cells will turn orange.
2. Color replacement, whether it is to replace the text color or the background color, the key is to select the cells to be replaced, and then change the color.
Watch video Excel replace *, special characters, formula and Highlight cells with formulas online without registration, duration hours minute second in high quality. This video was added by user Loinsure 07 April 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 212 once and liked it 1 people.