One way:

=A59 & " " & B59


In article ,
Jim wrote:

How do I add a space when merging two cells? I would like the space to be
between the two cells being merged.