merge two cel into ONE retaining the two values

[victork]

i need to merge into one cell (A1) the cells A1 and B1.
A1 contain the word DESCRIPTION
B1 contain the word CODE

I want to MERGE, not concatenate or use "& to join the information from A1
and B1, and have displayed only the information from A1.
A1 = DESCRIPTION

Can anyone help

 

[Gary''s Student]

If you run this macro:

Sub mergge()
Range("B1").Clear
Range("A1:B1").Merge
End Sub


then cells A1 and B1 will be merged and only the contents of A1 will be
displayed.

 

[Gord Dibben]

Your subject line is incorrect or your description is incorrect.

Subject says retaining the two values.

Description says only information from A1

That's how merge cells works.

Only the data from the top left cell is retained.

If you want both values in A1 but only A1 value to display, you will have to
concatenate in a third cell, change the formula to values, then hide the word
"CODE" with white font.


Gord Dibben MS Excel MVP