Gord Dibben Wrote:

=A1 & "-" & B1 returns 2-0


Bizarrly that IS what I was using, but without the spaces. Having put
the spaces in, it works perfectly.

I knew it'd be simple! :)

Very many thanks Gord,

Chris.


--
ChrisL
------------------------------------------------------------------------
ChrisL's Profile: http://www.excelforum.com/member.php...o&userid=37767
View this thread: http://www.excelforum.com/showthread...hreadid=573439