Forum Discussion

Copper Contributor

Jun 11, 2019

Make sentence from data in cells in Excel

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 ...

Formulas and Functions

office 365

training

SergeiBaklan

Diamond Contributor

Jun 11, 2019

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).")

Values to text.xlsx11 KB

thivanka101
Copper Contributor
Jun 11, 2019
Thank you so much sir! It helped
- SergeiBaklan
  Diamond Contributor
  Jun 11, 2019
  thivanka101 , glad to help