So you're using a formula like

=A1&" "&B1

The only reason I can see for a #VALUE! error there is that A1 or B1
contains a #VALUE! error


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=506764