Skip to main content

Concatenate with Italic text

  • March 15, 2022
  • 1 reply
  • 80 views

Forum|alt.badge.img+2

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?

1 reply

Forum|alt.badge.img+3
  • New Participant
  • March 14, 2024

I have a similar situation.  I am combining several fields into a single pipe-delimited list, and certain ones Id like to be bold or italic.  For example, how would I make:

{item1}&" | "&{item2}&" | "&{item3}&" | "&{item4}

Look like:

Item 1 | Item 2Item 3 Item 4


Rich text does not seem possible for Formula fields.