Excel 2007 : Merge cells & todays age/ date of birth

**andy9988** · 09-07-2010, 01:30 PM

Hi All,

I am facing a 2 problems .. can any one help me out in same ?????

1) Problem # 1

Is there any way to merge 3 different cells without losing "word" of each cell.

The things will get more clear if you see the attached excel sheet.

2) Problem # 2

Its a list of employees, where age is written at the time of joining. so is there any way to find today's age ? Is there any formula that picks any random date as per today's age ????

Please help me out...

Thnax,

Andy...

**daddylonglegs** · 09-07-2010, 01:36 PM

If you have birth date in F6 you can get age in years today with this formula

=DATEDIF(F6,today(),"y")

Where you don't have a birth date you can get an approximate age by adding the age at column A date to the years from that date, i.e.

=DATEDIF(A6,Today(),"y")+G6

so you could combine those to work in either situation like this

=DATEDIF(IF(ISNUMBER(F6),F6,A6),today(),"y")+IF(ISNUMBER(F6),,G6)

**andy9988** · 09-07-2010, 01:53 PM

Wht abt the 1st Problem ?????

I want to merge Column c , D & E i.e Merging 1st Middle and Last Name ?????

**ChemistB** · 09-07-2010, 02:23 PM

If you merge cells, you will only retain the information in the first cell. I would Insert a column between E and F (creating a new blank column F). Then in F6, dragged down

= C6 & " " & D6 & " " & F6

or rearraign if you want last name first.
Then Copy > Paste Special > Values to remove the formulas and make them constants. Then you can delete C,D and E.
Does that work for you?

**arthurbr** · 09-07-2010, 02:24 PM

Originally Posted by andy9988

Wht abt the 1st Problem ?????

I want to merge Column c , D & E i.e Merging 1st Middle and Last Name ?????

I suppose this means ddll's answer helped you for your 2nd question?
You might think about a simple and plain " thanks"

For your first question, see the CONCATENATE function