Thanks a Ton Master :-)
Working fine !!
have a gud day!
JP.
On Tue, Jul 17, 2012 at 11:03 AM, NOORAIN ANSARI
wrote:
> Dear JP,
>
> Please use below formula for desired output.
>
> =CONCATENATE(TEXT(A3,"mm.dd.yy")," ",TEXT(B3,"hh:mm:ss AM/PM"))
>
> or
>
> =TEXT(A3,"mm.dd.yy")&" "&TEXT(B3,"hh:mm
Dear JP,
Please use below formula for desired output.
*=CONCATENATE(TEXT(A3,"mm.dd.yy")," ",TEXT(B3,"hh:mm:ss AM/PM"))*
or
*=TEXT(A3,"mm.dd.yy")&" "&TEXT(B3,"hh:mm:ss AM/PM")
*See attached sheet for reference.*
*
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.bl
