Jun 10 2019 09:36 PM
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!
Jun 11 2019 12:45 AM
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).")
Jun 11 2019 12:47 AM