Retain value of merged cell in all unmerged cells
 

I have a table with a column of data that has merged cells with a value in
it, I would like to unmerge the cells, but retain the value of the cell in
all of the unmerged cells instead of only the top cell. Is there a way or
macro to do this?

Retain value of merged cell in all unmerged cells
 

After unmerging, highlight all the cells in that column in your table,
then press F5 (GoTo) and click on Special, then on blanks - you should
see only the blank (unmerged) cells highlighted. Then begin to type a
formula by entering = and then click on the cell immediately above the
first cell that is selected and then CTRL-ENTER. Now you can fix the
values in that column using <copy and Edit | Paste Special | Values.

Hope this helps.

Pete

On Jul 14, 10:39*pm, kari wrote:
I have a table with a column of data that has merged cells with a value in
it, I would like to unmerge the cells, but retain the value of the cell in
all of the unmerged cells instead of only the top cell. *Is there a way or
macro to do this?

Retain value of merged cell in all unmerged cells
 

Most excellent! thanks for the prompt and accurate reply

"Pete_UK" wrote:

After unmerging, highlight all the cells in that column in your table,
then press F5 (GoTo) and click on Special, then on blanks - you should
see only the blank (unmerged) cells highlighted. Then begin to type a
formula by entering = and then click on the cell immediately above the
first cell that is selected and then CTRL-ENTER. Now you can fix the
values in that column using <copy and Edit | Paste Special | Values.

Hope this helps.

Pete

On Jul 14, 10:39 pm, kari wrote:
I have a table with a column of data that has merged cells with a value in
it, I would like to unmerge the cells, but retain the value of the cell in
all of the unmerged cells instead of only the top cell. Is there a way or
macro to do this?

Retain value of merged cell in all unmerged cells
 

You're welcome - thanks for feeding back.

Pete

On Jul 14, 11:51*pm, kari wrote:
Most excellent! *thanks for the prompt and accurate reply