View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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