Make sentence from data in cells in Excel

Copper 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