Concatenation with Formating in bold and italics

I am trying to write a VBA code for concatenation and also format one column values to Bold and other to bold and italics. Unable to get through it . Please help

=CONCATENATE([@[Job Title]],CHAR(10),[@[Business Segment]],CHAR(10),[@[US Pay Band]],CHAR(10)," ",CHAR(10),"Incumbent - ",[@Name],CHAR(10)," ",CHAR(10),"Hay Points - ",[@[Final Hay Points]],CHAR(10))

here Job title should be bold and name should be bold and Italics