Forum Discussion
Copy value above a blank cell to the blank cell and replace a character in the copied value? In a co
I want to fill all blank cells in a column with the previous filled cell above it. Then find and replace one character in the copied value. Possible? Newbie.
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.
Vijaykumar Shetye,
Panaji, Goa, India