SOLVED

Take data from excel cells and make a sentence

%3CLINGO-SUB%20id%3D%22lingo-sub-3406886%22%20slang%3D%22en-US%22%3ETake%20data%20from%20excel%20cells%20and%20make%20a%20sentence%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3406886%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20form%20of%208%20cells%20(as%20you%20can%20see%20in%20the%20attached%20picture)%20%26amp%3B%20I%20need%20to%20get%20the%20values%20in%20a%20sentence%20like%20in%20the%20picture.%20If%20possible%20is%20there%20a%20way%20to%20calculate%20duration%20as%20well%20in%20the%20code%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Excel%20help.PNG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F373704i1B89E328BD1E2A01%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Excel%20help.PNG%22%20alt%3D%22Excel%20help.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20be%20kind%20enough%20to%20share%20a%20code%20with%20me%20to%20get%20this%20done%20ASAP.%20Thank%20in%20advance!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3406886%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3407083%22%20slang%3D%22en-US%22%3ERe%3A%20Take%20data%20from%20excel%20cells%20and%20make%20a%20sentence%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3407083%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1396158%22%20target%3D%22_blank%22%3E%40gettingittogether25%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DA2%26amp%3B%20%22%20%7C%20%22%26amp%3BTEXT(C2%2C%22%24%23%2C%23%230%22)%26amp%3B%22%20%7C%20%22%26amp%3BDATEDIF(D2%2CE2%2C%22m%22)%26amp%3B%22%20month(s)%22%26amp%3BCHAR(10)%26amp%3B%22Location%3A%20%22%26amp%3BG2%26amp%3B%22%2C%20US%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Geo%20Focus%3A%20%22%26amp%3BH2%26amp%3BCHAR(10)%26amp%3BF10%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20is%20not%20possible%20to%20make%20part%20of%20the%20result%20of%20the%20formula%20bold.%20Excel%20does%20not%20support%20that.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3407239%22%20slang%3D%22en-US%22%3ERe%3A%20Take%20data%20from%20excel%20cells%20and%20make%20a%20sentence%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3407239%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3BWorks%20like%20a%20dream!%20Thank%20you!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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? 

Excel help.PNG

 

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

2 Replies
best response confirmed by gettingittogether25 (New Contributor)
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.

@Hans Vogelaar Works like a dream! Thank you!