Hi,
If your text is in A1 and B1. Enter the following in the cell that you
are concatenating:
=A1 & " - " & B1
HTH,
SamuelT
--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile:
http://www.excelforum.com/member.php...o&userid=27501
View this thread:
http://www.excelforum.com/showthread...hreadid=560176