Forum Discussion

gettingittogether25's avatar
gettingittogether25
Copper Contributor
May 20, 2022
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 code? 

 

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

admin
excel
Formulas and Functions
training
  • HansVogelaar's avatar
    HansVogelaar
    May 20, 2022

    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.

2 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 20, 2022

    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.

Resources