Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Concatenate with Italic text

Topic Labels: Formulas
224 0
Showing results for 
Search instead for 
Did you mean: 

Hi All,
I want to create a bibliography. I have all the pieces in different columns and want to use the concatenate formula to pull them all together. However the Title of the book needs to be in Italics, how do I carry over the italics from the cells, or adjust the formula to make only the title Italic?
Author Surname, Initial(s). (Year) Title. Place of publication: Publisher.
This is my formula:
CONCATENATE({Author(s) Max 3},"(",Year,")","."," “,Title,” “, City,”:"," ",Publisher)

Any ideas?

0 Replies 0