Font formatting is lost when using rich text in Excel 2016 [WORKAROUND]

Last updated: October 11, 2017


When opening a file in Excel 2016 that contains multiple types of text formatting within the same cell, the formatting may be lost. Examples include having some rich text bolded and others in the same cell not bolded, or having different font colors for different characters within the same cell, such as the example below.