Yes there is! :D

Two fields containg data, can be merged like this:
A1 B1 C1
123 456 =A1&""&B1

Just write =A1&""&B1 in to the C1 cell.


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