May 20 2022 09:35 AM
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!
May 20 2022 10:12 AM
Solution
=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.
May 20 2022 10:56 AM
@Hans Vogelaar Works like a dream! Thank you!
May 20 2022 10:12 AM
Solution
=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.