- last edited on
04-14-2018 08:43 PM
This is possible, to do it:
Now you have all the blank cells selected, keep them selected and then go to the formula bar and type the cell address exists before the active cell.
For example, If the active cell of the selected blank cells is A4, then type =A3 and then hit Ctrl+Enter.
After that, you can find and replace what you want.
08-26-2018 12:19 AM
Hi Mark Wallen,
After you fill the blanks with the formula (as suggested by Haytham Amairah), you may need to replace the formulas with values, because you need to replace one character in the copied (pasted) value.
Do you want to replace one character in the formula or in the result of the formula?
Kindly elaborate and give an example for better clarity. You may also attach a sample file with test data. Your original data is not required in the sample file. You may enter data similar to what you have.
Panaji, Goa, India
by Luke_Skywalker on June 02, 2020
by PharmDoc on June 01, 2020
by tsaurus on June 01, 2020
by Alan Skelly on June 01, 2020
by cuong on May 27, 2020
by Ingeborg Hawighorst on May 13, 2020