merge and center data

[valerie]

I wanted my data value to be arranged in a way where it is in middle
alignment and are merged together as one whole column; without the
lines in between.
So I use the merge and center icon. But it says merging into one cell
will keep the upper-left most data only.
How to merge and center the data and yet retaining all the data value
at the same time?

 

[Peo Sjoblom]

=A2&B2

replace A and B with the columns you want to merge,
copy down, select and copy and paste special as values.
Finally center align the data. try to avoid merging from the format menu,
it is always causing some problems sooner or later