demerge mercge cells

[inungh]

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,

 

[Spiky]

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.

 

[Luke M]

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.

 

[Mike H]

Hi,

This will unmerge every thing in the used range

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


Mike

 

[Gord Dibben]

First you must unmerge the cells then try data>text to columns to split into
multiple columns.


Gord Dibben MS Excel MVP

 

[inungh]

First you must unmerge the cells then try data>text to columns to split into
multiple columns.

Gord Dibben  MS Excel MVP






- Show quoted text -

Thanks millions for the information,

 

[Mark]

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

 

[Spiky]

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.