merging cells without loosing info?

M

mhillis

Is there any way, using either Excel XP or 2003 along with windows XP
to merg cells together and not loose any of the information from any o
the cells, other than cut and paste
 
F

Frank Kabel

Hi
you would need VBA / a macro to do your merging.
note: I would recommend not to use merged cells as they cause several
problems (e.g. sorting, filerting, etc.)
 
J

JulieD

alternatively, you if it was the 'text' that you wanted to get into 1 cell,
you could combine the two (or more) pieces by concatenation and then use
that column.
e.g.
=A1 & " " B1 & " " & C1
will join together the contents of A1, B1 and C1 (separated by a space in
D1).
you could then select column D, choose copy, click on D1 and choose edit /
paste special - values
to replace the formula with the actual values - then you could delete A1,
B1 & C1, if required.

Regards
JulieD
 

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