I'm using Excel 2010
First, I have 2 cells. The first cell indicates the color in text - Red Orange Green Grey. The second cell also contains plain text. The data is exported from a SharePoint list.
I want to combine those in to one cell. The red will just be that color of the cell, and with the plain text in the second cell inside.
What should I do? Any formula for suggestion