merge two cel into ONE retaining the two values
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.
--
Gary''s Student - gsnu200769
"victork" wrote:
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
|