Excel Manual Merging without losing data

J

joceychin

Hi

in MS word, we can merge table cells without losing any data. However,
can we do that in Excel too ?

I cannot use any formular as i have variable no of rows to merger.
I have to review the rows before deciding which are the rows i want to
merge.
i have hundreds of rows to review and so it will be nice if i can find
a way to merge without losing data in the subsequent rows.

for some advice please.
thank you
Jocey
 
J

joceychin

MERGE has a very specific meaning in Excel that does not include retaining data other than in the upper left.  It also presents issues in subsequent access to data.

What, exactly, do you want to do?  If it is a matter of combining data in multiple rows, or hiding some data, that can be done; and usually automated by using VBA.

i was thinking of automating this tasks too. However, there is no
specific pattern of "merging" the rows.
the number of rows to merge is not fix. Someone is going to review the
rows manually first.
The task we are doing is more for documentation, and the merging is to
improve readability.
unless there is a way to write a macro to identify the selected cell
and then combine all the data together.
I do not know how to do it though.
 
I

isabelle

hi,

For Each c In Selection
If Not c = Empty Then txt = txt & " " & c
Next
With Selection
.ClearContents
.MergeCells = True
.WrapText = True
.ShrinkToFit = True
.VerticalAlignment = xlTop
End With
Selection = txt


--
isabelle


Le 2011-12-08 00:03, (e-mail address removed) a écrit :
It also presents issues in subsequent access to data.
that can be done; and usually automated by using VBA.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top