Forum Discussion
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 ...
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!
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!