Merged cell Formula

**RJ1969** · 09-14-2020, 07:10 PM

Hi All,

I need to insert a formula in a cell that has been merged i.e. C8-C11. I normally unmerge the cell in order for me to place the formula in it. Is there anyway to avoid unmerging the cells and still be able to put a formula in it?

Thanks.

**TMS** · 09-14-2020, 07:16 PM

Referring to cell C8 should do it ( if you must make that rod for your own back ).

**padapinto** · 09-14-2020, 07:33 PM

just put it direct even when the cells are merged and the formula will just work fine.

**RJ1969** · 09-14-2020, 07:42 PM

I tried but it did not work.

**TMS** · 09-14-2020, 09:36 PM

Post the workbook, let’s see what’s happening.

**bebo021999** · 09-14-2020, 10:09 PM

Originally Posted by RJ1969

Hi All,
I need to insert a formula in a cell that has been merged i.e. C8-C11. I normally unmerge the cell in order for me to place the formula in it. Is there anyway to avoid unmerging the cells and still be able to put a formula in it?
Thanks.

Do you attemp to put a formula in cell ,i.e, I10, while C8:C11 is merged by C8?
If yes, it is impossible.

**RJ1969** · 09-15-2020, 06:23 PM

Ok.. here is the sample worksheet. When I put the formula vlookup in Column C the formula does not work but if place the formula in Column D then it works.

Please tell me more. Thanks.

**TMS** · 09-15-2020, 06:37 PM

Looking at this on an iPad so I can't be 100% but it looks as if the merged cells are formatted as Text. Try formatting them as General and re-enter the formula (select, F2, Enter)