Register now or log in to join your professional community.
Column A = "Date of birth" Column B contains date =14/6/89 How to get Column C result = Date Of Birth is14/6/89
It can be done using this
=+CONCATENATE(A1," ","is"," ",TEXT(B1,"dd/mm/yy"))
Simple do as follows:
Column A heading is Date of Birth and containing data..
Column B write ="Date of Birth is "&TEXT(A2,"dd/mm/yyyy")
That's it....
In the collumn c2 type the below formula
=A2&" "&TEXT(B2,"dd/mm/yy")
Well, you can go with the basic way, which is:
=A1&" "&"is"&" "&B1
1- You have to enter Equal first to start typing the function.
2- A1, is suppose to be the cell that contain (Date of Birth)
3- you need space, but before you add space, you need to tell Excel that you are going to add something else next to (Date of Birth). To tell Execl, you put (&).
4- then you put " " <--(which is space)
5- then you tell excel that you are going to add something else which is (is). so , you start with (&) again.
6- then you have to put is between quote --> "is"( anything between quote will be on the cell)
7- again we talk to Excel & ( we want to add something)
8- " " Space
9- again we talk to Excel & ( we want to add something)
10- and here we add the date which is Cell B1. I'm saying1 because I'm assuming that the date is in Raw1 Column B. The questioner did not specify the raw number.
Thank you
= Col1&" is "&Col B
=TEXT(A1,) & B1
I am agree with all of them who suggests to use "concatenate"
put this formula in coulmn c.....} =CONCATENATE(A text,B text)
The excel format to get the above is
=CONCATENATE(A1, text(B1, "dd/m/yy"))
you will get your requirement.
