View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default the merge cell contents formula is not working- why?

have you tried:

=Concatenate(a4,b4)

or

=a4&b4

?

On 24 Gru, 07:33, Ze Question <Ze
wrote:
I am trying to merge contents of two adjacent cells. *What I get i sthe
formula and nto the result I have used "=a4&b4" and ="Concatenate(a4,b4)" and
they both do not work. *Any help why