demerge mercge cells
 

I have a merge cell and would like to seperate them in to individual
cells.
I just wonder any functions to do so?


Your information is great appreciated,

demerge mercge cells
 

On Dec 19, 11:42*am, inungh wrote:
I have a merge cell and would like to seperate them in to individual
cells.
I just wonder any functions to do so?

Your information is great appreciated,

"Merge" is a format command. It is not a function command. Just turn
off the Merge format.

Unless you mean something else. In that case, I think you need to
explain it more.

demerge mercge cells
 

If its a single merged cell, you can click the merge cell button again to
demerge. If you want to demerge multiple cells, you can go to
view-toolsbars-custom, and find the "Unmerge cells" button and add it to your
toolbar for future use.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Spiky" wrote:

On Dec 19, 11:42 am, inungh wrote:
I have a merge cell and would like to seperate them in to individual
cells.
I just wonder any functions to do so?

Your information is great appreciated,

"Merge" is a format command. It is not a function command. Just turn
off the Merge format.

Unless you mean something else. In that case, I think you need to
explain it more.

demerge mercge cells
 

Hi,

This will unmerge every thing in the used range

Sub Merge_UN()
ActiveSheet.UsedRange.MergeCells = False
End Sub


Mike

"inungh" wrote:

I have a merge cell and would like to seperate them in to individual
cells.
I just wonder any functions to do so?


Your information is great appreciated,

demerge mercge cells
 

First you must unmerge the cells then try datatext to columns to split into
multiple columns.


Gord Dibben MS Excel MVP

On Fri, 19 Dec 2008 09:42:24 -0800 (PST), inungh wrote:

I have a merge cell and would like to seperate them in to individual
cells.
I just wonder any functions to do so?


Your information is great appreciated,

demerge mercge cells
 

On Dec 19, 4:21*pm, Gord Dibben <gorddibbATshawDOTca wrote:
First you must unmerge the cells then try datatext to columns to split into
multiple columns.

Gord Dibben *MS Excel MVP



On Fri, 19 Dec 2008 09:42:24 -0800 (PST), inungh wrote:
I have a merge cell and would like to seperate them in to individual
cells.
I just wonder any functions to do so?

Your information is great appreciated,- Hide quoted text -

- Show quoted text -

Thanks millions for the information,

demerge mercge cells
 

Mike,

How do you apply this code, as I have numerous merged cells I need to
unmerge. Too Many do do one at a time?

Thanks Mark

"Mike H" wrote:

Hi,

This will unmerge every thing in the used range

Sub Merge_UN()
ActiveSheet.UsedRange.MergeCells = False
End Sub


Mike

"inungh" wrote:

I have a merge cell and would like to seperate them in to individual
cells.
I just wonder any functions to do so?


Your information is great appreciated,

demerge mercge cells
 

On Feb 7, 10:57*pm, Mark wrote:
Mike,

How do you apply this code, as I have numerous merged cells I need to
unmerge. Too Many do do one at a time?

The only reason to use the code is if you are already making a macro
to do other things. Otherwise, there isn't much point as it is already
included in Excel as a direct command. See the other posts in this
thread.

But the answer to your question is to select all the cells you wish to
unmerge first. It works on multiple merged groups of cells. Select the
whole worksheet if you want to get rid of every single merge.