How to incorprate value of another cell into wanted cell.

So basically in any cell i have the following text written.

Name:
Age:
Birth:

how do i make it so after the cologn the value of A1 comes, then after Age the value of cell A2, and Birth A3. So for example if the value of A1 is ben, and the value of A2 is 2 and the value of A3 is 1993. It should look like the following:


Name: ben
Age: 2
Birth: 1993


i Tried the following but it did not work.
Name: =A1
Age: =A2
Birth: =A3

I tried that but it just gives the cell a value of false

Hi

Set the cells formatting to "Wrap Text" for all teh Output text range.

Then use the following formula ...
="Name: "&A1&CHAR(10)&"Age #: "&B1&CHAR(10)&" Birth: "&C1

CHAR(10) being the "Return" within a Cell where the Wrap Text is on.

Stephen

Hi Behnam
Try this formula:

="Name: " & A1 & CHAR(10)&"Age #: " & B1 & CHAR(10) & "Birth: " & C1

Make sure you set you cell to wrap text.
Good luck.
Tony

This worked perfectly, thanks ARGK, you got my reputation!!

Thanks for the feedback.