Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

Column A = "Date of birth" | Column B contains date =14/6/89 | How to get Column C result = Date Of Birth is14/6/89

Column A = "Date of birth" Column B contains date =14/6/89 How to get Column C result = Date Of Birth is14/6/89

user-image
Question ajoutée par Ahmed Aziz , Software Development & Testing , Innernet, Inc.
Date de publication: 2014/03/20
Pravin Muthuswamy
par Pravin Muthuswamy , Project Engineer , Brigade Enterprises Ltd

It can be done using this

=+CONCATENATE(A1," ","is"," ",TEXT(B1,"dd/mm/yy"))

 

Zulfiqar Ali
par Zulfiqar Ali , Data Analyst , Tech Consulting

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

Moin Mohamed
par Moin Mohamed , Sr. Purchasing Analyst, , Al-Khafji Joint Operation - KJO

In the collumn c2 type the below formula

=A2&" "&TEXT(B2,"dd/mm/yy")

Abdullah Alhammad
par Abdullah Alhammad , System Developer , Children Museum Missoula

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

 

 

Utilisateur supprimé
par Utilisateur supprimé

Use this formula in column C

=A1&" "&B1

Abdul Wasay Hassan
par Abdul Wasay Hassan , Deputy Manager Internal Audit , Pak Suzuki Motor Company Ltd.

= Col1&" is "&Col B

Helal Uddin
par Helal Uddin , Manager and Head of HR Operation , Amin Mohammad Group

=TEXT(A1,) &  B1

 

Mohammed Hayat Ahmed
par Mohammed Hayat Ahmed , Team Lead-IT DataCenter Operations , Confidential

I am agree with all of them who suggests to use "concatenate"

ALLAH DITTA
par ALLAH DITTA , Accountant , Master Beverages & Food Limited

put this formula in coulmn c.....} =CONCATENATE(A text,B text)

BHUPATHI  REDDY MALLIDI
par BHUPATHI REDDY MALLIDI , Manager HR And Admin , Manthena American School

The excel format to get the above is

=CONCATENATE(A1, text(B1, "dd/m/yy"))

you will get your requirement.

More Questions Like This