Concate two cell values in one cell with different formating

[atuljadhavnetafim]

Dear Expert

I have 8 columns in which the first four columns show value in INR and the rest four value in USD, so in presentation, I need to put this entire 8 column to present.
now I want to show value in INR and USD in single-cell but the formation of INR and USD must be different, like INR value shown in Blue color and font 10 sizes while USD value in Green color and font 8 sizes.


Currenlty show as below.

expected result

Excel allow me to change the color and font size but when i exit the cell it is not reflected in display.

any way to show in single cell INR and USD value with different formatting .

Best of luck and Thanks in advance

 

[severynm]

Do they need to be in a single cell? What if you had two cells, with each being half of the size? It would be much easier to independently control formatting that way.

 

[atuljadhavnetafim]

Yes, I did in the same way, just wondering if possible so I can reduce the space between two numbers because this is the minimum column width

 

[severynm]

You are allowed to have text different colors in the same cell, but it must be text and cannot be a formula. It looks to me like you can also manually make those columns smaller.