In D1

= C1 & " replaces " & A1

In D2
= C1 & ", " & A2

then replicate D2 down



"Lakewoodsale" wrote:

Have a part number listed in A column, it refers a new updated part number in
column C. I would like to concatenate it to a line of text. (or maybe a
macro would be better)

Column and numbers look like this:

Column A Column B Column C
Old number use new number New Number
01-261-0340 use new number 01-261-0340-01
95-0885 use new number 01-261-0340-01
95-0885-01 use new number 01-261-0340-01

I want to get it so it reads in a line of Text as:
01-261-0340-01 replaces 01-261-0340 , 95-0885 , 95-0885-01

Thanks for looking, and any help would be appreciated.