You could concatenate the two cells together instead of merging them. If
the two cells are A1 and B1 the equation goes like this.

=concatenate(A1,B1)

That will take the information from cell A1 and merge it with B1 and
anything else you want to add to all the cells can be added by putting
another comma in and specifying what you want to add, i.e.

=concatenate(a1," ", b1) - would put a space between the two pieces of
text.

=concatenate(a1,"-",b1) - would put a dash between the two pieces of
text.

=concatenate(a1,b1,"This is cool") - would put This is cool after the
two pieces of text.

Hope that helps
Chris


--
chrisnelsonusa1
------------------------------------------------------------------------
chrisnelsonusa1's Profile: http://www.excelforum.com/member.php...o&userid=29526
View this thread: http://www.excelforum.com/showthread...hreadid=492272