Forum Discussion
Solved
Take data from excel cells and make a sentence
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...
=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.
=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.
HansVogelaar Works like a dream! Thank you!