Chris,
CONCATENATE is a completely unnecessary function, & does it just as well,
and is more self-explanatory IMO.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"chalky" wrote in
message ...
Ah perfect, that is exactly what i was trying to get to with CONCATENATE
but your way is loads better. Well for a start it works!
Cheers
Chris
--
chalky
------------------------------------------------------------------------
chalky's Profile:
http://www.excelforum.com/member.php...o&userid=23758
View this thread: http://www.excelforum.com/showthread...hreadid=483089