Concatenate 2 fields - preserve bolding

[psycoperl]

Good Morning - I have 2 columns that I am wanting to concatenate together. So I was using the Concat() function. However, one column has bolded text. Is there a way to preserve this in the concatnation?

Book1
	C	D	E	F
1	Column1	Keep/Delete	Qualtrics Survey Name	Description/Notes
2	1159_CLA_Appointment CLA Appointment Registration forms from Fall 2015. These forms were where students signed up for a specific session. There was no other data collected	Keep / Delete/ Other	1159_CLA_Appointment	CLA Appointment Registration forms from Fall 2015. These forms were where students signed up for a specific session. There was no other data collected
3	1162_CLA_Appointment CLA Appointment Registration forms from Spring 2016? These forms were where students signed up for a specific session. There was no other data collected	Keep / Delete/ Other	1162_CLA_Appointment	CLA Appointment Registration forms from Spring 2016? These forms were where students signed up for a specific session. There was no other data collected
Sheet1

Cell Formulas
Range	Formula
C2:C3	C2	=CONCAT(E2,CHAR(13),CHAR(10),F2)

For example

1159_CLA_Appointment CLA Appointment Registration forms from Fall 2015. These forms were where students signed up for a specific session. There was no other data collected

Should be

1159_CLA_Appointment CLA Appointment Registration forms from Fall 2015. These forms were where students signed up for a specific session. There was no other data collected

 

[Fluff]

No there isn't, the only way would be to use VBA but then the cell would have to be a hard value, rather than as formula.

 

[psycoperl]

Ok. Was hoping... Will just make the first line all CAPS to differentiate it.

 

[Fluff]

Glad to help & thanks for the feedback.