If the text "aaa" is in cell b1 then type the formula below in the cell
you would like to concatenate the information into.

=B1&"-"&A1

Hope this helps
Ed


--
nuver
------------------------------------------------------------------------
nuver's Profile: http://www.excelforum.com/member.php...o&userid=10036
View this thread: http://www.excelforum.com/showthread...hreadid=492631