Join data in two cells

**nvsanilkumar** · 01-17-2012, 07:14 AM

Sir

With concatenate function I tried to join ref number and date column. But date is coming in digits. Please help how to see date in the joined cell.

Sheet enclosed

Thanks in advance

Anil

**Andrew-R** · 01-17-2012, 07:25 AM

Try:

=A2 & TEXT(B2,"dd-mmm-yy")

**TMS** · 01-17-2012, 07:27 AM

Cell C2 formula: =A2&" "&TEXT(B2,"dd-mmm-yy")

and copy down

Regards, TMS

**nvsanilkumar** · 01-18-2012, 03:27 AM

Its working thanks for the help

**TMS** · 01-18-2012, 03:57 AM

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save