Take data from excel cells and make a sentence

[gettingittogether25]

Hi,

I have a form of 8 cells (as you can see in the attached picture) & I need to get the values in a sentence like in the picture. If possible is there a way to calculate duration as well in the code? 

Please be kind enough to share a code with me to get this done ASAP. Thank in advance! 

[#2 · Accepted solution]

@gettingittogether25 

=A2& " | "&TEXT(C2,"$#,##0")&" | "&DATEDIF(D2,E2,"m")&" month(s)"&CHAR(10)&"Location: "&G2&", US       Geo Focus: "&H2&CHAR(10)&F10

It is not possible to make part of the result of the formula bold. Excel does not support that.

[#3]

@Hans Vogelaar Works like a dream! Thank you!