Forum Discussion

Oliullah_Siddique's avatar
Oliullah_Siddique
Brass Contributor
Jun 23, 2022
Solved

Add text from multiple cells

Dear everyone,    Please give me a Formula in A4 to add cell A1, A2 & A3.    Thanks in advance.       A 1 The Financial Statements of the Company have been prepared on a going concern ...
excel
  • Mark_My_Words's avatar
    Mark_My_Words
    Jun 23, 2022

    Hi Oliullah_Siddique 

     

    Formula in cell A4 is: =CONCAT(A1,TEXT(A2,"dd-mmm-yy")," to ",TEXT(A2,"dd-mmm-yy"),".")

     

    The above formula works in this particular situation, but may not work in other situations.

     

     

    If I was able to help You, please Like My answer and mark it as the Best Response.

     

    Thank You!

Oliullah_Siddique's avatar
Oliullah_Siddique
Brass Contributor
Jun 23, 2022
Thanks sivakumarrj.

I tried the formula but its not working.

The excel file has been attached. Would you please reply me with the Excel file.

Thanks again.

Resources