Formatting 2 strings in cell in different ways

[ardykav]

I have 2 columns, Column A has a regularly formatted first name. Calibri 11. It is also a look up formula from another sheet.

Column B is Surname which is also a lookup formula from another sheet but I have used the Upper function on it to make it all upper case and also bolded the column.

I am wondering is there any way to have all of these in one cell with the formatting preserved?

I suppose the hard part is just getting the bold part on the surname

All help greatly appreciated

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.