Is this what you are looking for:
=a1&"<br /"&right(a2,7)&"<br /"&right(a3,7)&"<br /"&right(a4,7)
?

Regards,
Fred

"EllenM" wrote in message
...
Hello,
I have a data set that looks like this:
Sortterm Doc # Main Term CAS # CFR REG #
DIPHTHALATE 7065 DI(2-ETHYLHEXYL) PHTHALATE 000117817 175.105
DIPHTHALATE 7065 DI(2-ETHYLHEXYL) PHTHALATE 000117817 175.300
DIPHTHALATE 7065 DI(2-ETHYLHEXYL) PHTHALATE 000117817 175.380
DIPHTHALATE 7065 DI(2-ETHYLHEXYL) PHTHALATE 000117817 175.390
DIPHTHALATE 7065 DI(2-ETHYLHEXYL) PHTHALATE 000117817 176.170

I'd like to concatentate the last column with the unique values to look
like
this:
Sorterm DocNum Mainterm CAS Regnum
DIPHTHALATE 7065 DI(2-ETHYLHEXYL) PHTHALATE 000117817 175.105<br
/175.300<br /175.380<br /175.390<br /176.170
Thanks in advance,
Ellen