Home

Make sentence from data in cells in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-682243%22%20slang%3D%22en-US%22%3EMake%20sentence%20from%20data%20in%20cells%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-682243%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%204%20cells%20(as%20you%20can%20see%20in%20the%20attached%20picture)%20%26amp%3B%20I%20need%20to%20get%20the%20values%20within%20brackets%20of%20the%20sentence%20filled%20when%20updating%20data%20in%20A2%2C%20B2%2C%20C2%20%26amp%3B%20D2.%26nbsp%3B%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%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-682243%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcl%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-682486%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20sentence%20from%20data%20in%20cells%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-682486%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F357911%22%20target%3D%22_blank%22%3E%40thivanka101%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20could%20be%3C%2FP%3E%0A%3CPRE%3E%3DA1%20%26amp%3B%20%22%20(%22%20%26amp%3B%20TEXT(A2%2C%22m%2Fd%2Fyyyy%22)%20%26amp%3B%20%22)_(%22%20%26amp%3B%20B2%20%26amp%3B%20%22)%20-%20Active%20coverage%20since%20%22%26amp%3B%20TEXT(C2%2C%22m%2Fd%2Fyyyy%22)%20%26amp%3B%20%22%2C%20Specialist%20co-pay%20%22%20%26amp%3B%20TEXT(D2%2C%22%5B%24%24-en-US%5D(%23%2C%23%230.00).%22)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-682487%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20sentence%20from%20data%20in%20cells%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-682487%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much%20sir!%20It%20helped%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-683656%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20sentence%20from%20data%20in%20cells%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-683656%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F357911%22%20target%3D%22_blank%22%3E%40thivanka101%3C%2FA%3E%26nbsp%3B%2C%20glad%20to%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E
thivanka101
New Contributor

Hi,

 

I have a form of 4 cells (as you can see in the attached picture) & I need to get the values within brackets of the sentence filled when updating data in A2, B2, C2 & D2. 

 

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

 

 

 

3 Replies

@thivanka101 

 

It could be

=A1 & " (" & TEXT(A2,"m/d/yyyy") & ")_(" & B2 & ") - Active coverage since "& TEXT(C2,"m/d/yyyy") & ", Specialist co-pay " & TEXT(D2,"[$$-en-US](#,##0.00).")
Thank you so much sir! It helped

@thivanka101 , glad to help