Fellow Forum Members,
I have a list of 200 outdated part numbers inside Column A. The font properties for all Column A numbers is setup to display all the numbers as RED and with a Strikthrough Line.
In Column B, I have a list of the NEW Part Numbers that are going to replace the old part numbers. All these numbers are shown in black and with NO Strikethrough.
When I use this Concatenate function in Cell C1:
=Concatenate(A1," - ",B1)
Excel drops the font formatting I had setup for the Column A numbers. How do I edit my Concatenate function so that it keeps the RED colored numbers aswell as the Strikthrough font property? In short, I need cell C1 to show the old part number as RED with strikthrough and also the New Part Number as black all within the C1 cell. Is using the TEXT function together with the Concatenate function the solution? Something like: =Concatenate(Text(A1)," - ",B1)). I tried it and it doesn't work.
Any help will be greatly appreciated. Thanks.