E
Elfego Baca
I have 5 cells filled:
A1 regular
A2 bold
A3 italic
A4 bold italic
A5 underline
Cell A6 uses the formula =CONCATENATE(A1," ",A2," ",A3," ",A4," ",A5)
This creates the following in Cell A6 regular bold italic bold italic
underline
I would like to be able to control the properties of each part of the
concatenated cell so that the word bold is a bold font, the word italic
is in an italic font, the words bold italic are in a bold and italic
font and the word underline is underlined. How do I put htis in the
formula to get each word done properly?
A1 regular
A2 bold
A3 italic
A4 bold italic
A5 underline
Cell A6 uses the formula =CONCATENATE(A1," ",A2," ",A3," ",A4," ",A5)
This creates the following in Cell A6 regular bold italic bold italic
underline
I would like to be able to control the properties of each part of the
concatenated cell so that the word bold is a bold font, the word italic
is in an italic font, the words bold italic are in a bold and italic
font and the word underline is underlined. How do I put htis in the
formula to get each word done properly?